Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Writing Details into Excel File

 
ashok r
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi There,

I need to write the retrived values from database into a excel file. Can any one help me to sought this problem out.
 
Ulf Dittmer
Rancher
Posts: 42970
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Both POI (on jakarta.apache.org) and jExcelAPI (on sourceforge.net) are libraries that can generate Excel files.
 
payal agrawal
Ranch Hand
Posts: 44
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Look at the URL below:

How to view database data in XLS format using servlets
http://www.java-tips.org/content/view/849/74/

The example in above URL is for viewing data in web browser, but if you remove the servlet part it will serve your purpose.
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!