?
Solved

Displaying an EXCEL spreadsheet file througfh Java

Posted on 1998-04-16
2
Medium Priority
?
275 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 300 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

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

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

This was posted to the Netbeans forum a Feb, 2010 and I also sent it to Verisign. Who didn't help much in my struggles to get my application signed. ------------------------- Start The idea here is to target your cell phones with the correct…
Java functions are among the best things for programmers to work with as Java sites can be very easy to read and prepare. Java especially simplifies many processes in the coding industry as it helps integrate many forms of technology and different d…
Viewers will learn about if statements in Java and their use The if statement: The condition required to create an if statement: Variations of if statements: An example using if statements:
This theoretical tutorial explains exceptions, reasons for exceptions, different categories of exception and exception hierarchy.
Suggested Courses
Course of the Month9 days, 17 hours left to enroll

762 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