Win a copy of Murach's Python Programming this week in the Jython/Python forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

JSP to Excel spreadsheetS  RSS feed

 
Joseph Smithern
Ranch Hand
Posts: 89
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I can create one Excel spreadsheet but how do I create two spreadsheets using JSP?

This creates just one but I need to create the Excel file with two spreadsheets of info:

 
Ben Souther
Sheriff
Posts: 13411
Firefox Browser Redhat VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
JSP can not create a true Excel sheet.

The best it can do is take advantage of Excels ability to work with CSV or HTML formatted text files. In order to do complex things, such as create multiple sheet files, from JSP/Java, you will need to find a third party library that knows how to work with true Excel files.

There are some listed in our JSP Faq under JspAndExcel.
 
Kamesh Rao
Ranch Hand
Posts: 35
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Yes as suggested you can use a third party library like Apache HSSF API
 
Ulf Dittmer
Rancher
Posts: 42970
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Since there will be a good deal of Java coding involved, it would be much better to do this in a servlet or backing bean. Libraries like Jakarta POI or jExcelAPI can create Excel files quite easily.
 
Alex Sotin
Greenhorn
Posts: 21
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi here you can find how you can do it, hope it will help you.
http://j-integra.intrinsyc.com/support/com/doc/servlet_com/excel_example_servlet.html
 
Prafulla N. Patil
Ranch Hand
Posts: 106
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
you can use Apache POI HSSF API
it will surely solve your problem, i have used it
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!