File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases 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 and Relational Databases
Bookmark "Java to excel format" Watch "Java to excel format" New topic

Java to excel format

Soumya Ghosh

Joined: Dec 31, 2006
Posts: 26
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.

[Blog][Linkedin] How To Ask Questions On JavaRanch My OpenSource
I agree. Here's the link:
subject: Java to excel format