[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Displaying an EXCEL spreadsheet file througfh Java

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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

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…
Go is an acronym of golang, is a programming language developed Google in 2007. Go is a new language that is mostly in the C family, with significant input from Pascal/Modula/Oberon family. Hence Go arisen as low-level language with fast compilation…
The viewer will learn how to implement Singleton Design Pattern in Java.
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …
Suggested Courses

656 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