Solved

Displaying an EXCEL spreadsheet file througfh Java

Posted on 1998-04-16
2
260 Views
Last Modified: 2010-04-16
I like to display an EXCEL spreadsheet file through my
Java applet. Can it be done? If yes, what resources will be needed? I need some help in starting this program.
0
Comment
Question by:sattar
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
2 Comments
 
LVL 6

Accepted Solution

by:
jpk041897 earned 100 total points
ID: 1234125
Yes, it can be done but it will require that you either define an Excel Data Base asociated with your spreadsheet or that you publish the spreadsheet as an HTML file.

If you choose the DB method, you will need to use the JDBC/ODBC bridge and an Excel ODBC driver (the one that comes with Office is good enough). Then using JDBC you can read the info on the Excel DB and display it any way you want. This option gives you the most flexibility.

If you choose the HTML road, your applet will need to open a socket to file and parse its contents.

You can of course expoert the Excel spreadsheet to a comma delimited (or other ASCII based) file and access similarly. The problem with these methods is a loss of flexibility and the need to export the spreadsheed to another format.

In any case, it would probably be wisest if you purchase one of the grid libraries to actualy display/edit the data, such as the one at http://www.stingsoft.com/ogj/default.asp
0
 
LVL 6

Expert Comment

by:jpk041897
ID: 1234126
As another simpler (but more expensive option) you might want to look at:

http://www.athena.com/

which contains a contributed and distributed applet enabled spreadsheet with legacy Excell support.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
spring jars download 1 67
dao vs facade design patterns 2 69
Html split(text) 2 48
What does this method description mean? 1 10
INTRODUCTION Working with files is a moderately common task in Java.  For most projects hard coding the file names, using parameters in configuration files, or using command-line arguments is sufficient.   However, when your application has vi…
Introduction This article is the last of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article covers our test design approach and then goes through a simple test case example, how …
Viewers will learn about arithmetic and Boolean expressions in Java and the logical operators used to create Boolean expressions. We will cover the symbols used for arithmetic expressions and define each logical operator and how to use them in Boole…
This theoretical tutorial explains exceptions, reasons for exceptions, different categories of exception and exception hierarchy.
Suggested Courses

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question