Displaying an EXCEL spreadsheet file througfh Java

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.
sattarAsked:
Who is Participating?
 
jpk041897Connect With a Mentor Commented:
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
 
jpk041897Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.