GeeCON Prague 2014*
The moose likes Other Open Source Projects and the fly likes importing data from database to excel sheet through JExcel Api Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Products » Other Open Source Projects
Bookmark "importing data from database to excel sheet through JExcel Api" Watch "importing data from database to excel sheet through JExcel Api" New topic
Author

importing data from database to excel sheet through JExcel Api

akki gupta
Greenhorn

Joined: Nov 01, 2011
Posts: 9
how to import data from the database to an excel sheet using JExcel Api through JSP page?
Ifteqar Ahmed
Ranch Hand

Joined: May 02, 2011
Posts: 85

Step 1: The following code Creates an Excel File using JXL API.






Step2 : The following Function writes data to the Excel Sheet.




I have just given you the Idea about How to import Values from database to Excel Sheet. Modify the code as per your Requirements.

Thanks.......
akki gupta
Greenhorn

Joined: Nov 01, 2011
Posts: 9
thanks....:)
Miku Ranjan
Ranch Hand

Joined: Oct 11, 2011
Posts: 98
Hi,
There is another way of using jxl you can use jxl tag directly in xls file.
 
GeeCON Prague 2014
 
subject: importing data from database to excel sheet through JExcel Api