File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes How to store an oracle database table's data to an excel file? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "How to store an oracle database table Watch "How to store an oracle database table New topic
Author

How to store an oracle database table's data to an excel file?

Nikhil Reddy Lingala
Greenhorn

Joined: Dec 06, 2007
Posts: 15
Hi,
I am doing a small application using JSP, Servlets, Oracle DataBase express edition.
In this, I store some data into a particular table of the database from the application. The user of the application wants the data from that table to have it stored in an excel file.
To be specific, I have to provide an option for the user to delete a particular "vehicle" under operation from the application after its agreement expires. But the user wants all the data in an excel file.
How do I do it?
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

Apache POI is how you would populate the Excel file. You can then stream this to the client. However, depending on their browser and its set up it will either give you a "save file" dialog or will render the Excel file in the browser.


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
jeroen dijkmeijer
Ranch Hand

Joined: Sep 26, 2003
Posts: 131
oracle - excel
Nikhil Reddy Lingala
Greenhorn

Joined: Dec 06, 2007
Posts: 15
I understood that I should use Apache POI API for my application in order to convert database tables to excel.
Do I need to do any pre-configuration for that? like writing an xml file... or that kind of stuff??
and one more thing.. how do I get the javadocs download for Apache POI?
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

Originally posted by Nikhil Reddy Lingala:
I understood that I should use Apache POI API for my application in order to convert database tables to excel.
Do I need to do any pre-configuration for that? like writing an xml file... or that kind of stuff??
and one more thing.. how do I get the javadocs download for Apache POI?


Preconfiguration? No. Read through the POI docs, there are example and the like.

The JavaDocs are available online. I'm not sure if they are included in the download. You can always build them from the source though.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: How to store an oracle database table's data to an excel file?