• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

importing data from database to excel sheet through JExcel Api

 
akki gupta
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
how to import data from the database to an excel sheet using JExcel Api through JSP page?
 
Ifteqar Ahmed
Ranch Hand
Posts: 85
Java Linux MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
thanks....:)
 
Miku Ranjan
Ranch Hand
Posts: 98
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
There is another way of using jxl you can use jxl tag directly in xls file.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic