aspose file tools*
The moose likes JDBC and the fly likes how to export database(oracle) data to excel.. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Soft Skills this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "how to export database(oracle) data to excel.." Watch "how to export database(oracle) data to excel.." New topic
Author

how to export database(oracle) data to excel..

indu yeturu
Ranch Hand

Joined: Aug 27, 2008
Posts: 123
Hi

can you please tell me how to export data from database (oracle) to excel..If possible please suggest a good site of example for this..


thanks,
indu
Fatih Keles
Ranch Hand

Joined: Sep 01, 2005
Posts: 182
Hi indu,

You can create a regular csv file with java.io.file package components. Or you can go after Apache POI and JExcelApi for Microsoft Excel file format. You may find lots of examples in the specified API documentation pages.
Assuming that you have to do it with your own code. Other wise you can export data with any pl/sql editor by hand.

Regards,

Fatih.
Jan Cumps
Bartender

Joined: Dec 20, 2006
Posts: 2516
    
  10

You can try Fatih's first solution (the regular csv file), and give the filename an .xls extension.
Regards, Jan


OCUP UML fundamental and ITIL foundation
youtube channel
indu yeturu
Ranch Hand

Joined: Aug 27, 2008
Posts: 123
thank you somuch ... I will try it ...
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: how to export database(oracle) data to excel..