aspose file tools*
The moose likes JDBC and the fly likes Java to excel format Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Java to excel format" Watch "Java to excel format" New topic
Author

Java to excel format

Soumya Ghosh
Greenhorn

Joined: Dec 31, 2006
Posts: 26
Hi,
I am facing problem regarding the following-------

I want to take some values from Oracle database using thin driver.
The items are stored in ResultSet and populated in String.

Then I want to convert the resultset or the items collected, in Microsoft Excel format.
That means I want to generate report using Microsoft excel using the items from JDBC.How can I do that? Can any one please send me a sample code?
Muhammad Saifuddin
Ranch Hand

Joined: Dec 06, 2005
Posts: 1321

try this link to create an Excel Sheet from your ResultSet Object..
Create excel from JDBC resultset
hope it helps.


Saifuddin..
[Blog][Linkedin] How To Ask Questions On JavaRanch My OpenSource
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Java to excel format
 
Similar Threads
Want to read MS-Excel Sheet Throgh Xml and Store it into DataBase using JDBC
How to call Excel to display data?
Microsoft Office SDK for java
Export JSP page to Excel
Creating Excel File - POI