aspose file tools*
The moose likes JDBC and the fly likes export the data retrieved through a query into 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 "export the data retrieved through a query into excel" Watch "export the data retrieved through a query into excel" New topic
Author

export the data retrieved through a query into excel

pavanirag kumar
Greenhorn

Joined: Dec 07, 2006
Posts: 3
hi


please let me know the procedure as how to store each field that has come as an output of a query into each cell in excel.
Jeanne Boyarsky
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 31057
    
232

Pavanirag,
Welcome to JavaRanch!

The easiest way is to create a common separated file yourself. This opens in Excel as data. If you need formatting, try a library like HSSF.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: export the data retrieved through a query into excel