File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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.
 
 
subject: importing data from database to excel sheet through JExcel Api
 
Similar Threads
importing data from database to excel sheet through JExcel Api
How To compare two excel sheets using java
Extracting data from Excel sheet through servlets in linux
Oracle 9i to Excel Sheet
jxl package doenot exists