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 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 Murach's Java Servlets and JSP this week in the Servlets 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
internet detective
Marshal

Joined: May 26, 2003
Posts: 30068
    
149

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
 
 
subject: export the data retrieved through a query into excel
 
Similar Threads
opening xls fine in web Browser using jsp
save query result
How to retrieve data from excel
Incorrect Colum/Size Error while converting from java to excel
Transfer Excel Sheet information to database