Solved

Displaying an EXCEL spreadsheet file througfh Java

Posted on 1998-04-16
2
227 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
  • 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

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
hash value 2 38
Books that can get me started on JAVA 2 56
compre toata in where clue oracle 4 44
recursion example 16 70
Java contains several comparison operators (e.g., <, <=, >, >=, ==, !=) that allow you to compare primitive values. However, these operators cannot be used to compare the contents of objects. Interface Comparable is used to allow objects of a cl…
Java Flight Recorder and Java Mission Control together create a complete tool chain to continuously collect low level and detailed runtime information enabling after-the-fact incident analysis. Java Flight Recorder is a profiling and event collectio…
Viewers learn about the third conditional statement “else if” and use it in an example program. Then additional information about conditional statements is provided, covering the topic thoroughly. Viewers learn about the third conditional statement …
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…

746 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now