aspose file tools*
The moose likes JSP and the fly likes JSP to Excel sheet Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Java » JSP
Bookmark "JSP to Excel sheet" Watch "JSP to Excel sheet" New topic
Author

JSP to Excel sheet

Sahana Hegde
Ranch Hand

Joined: Jan 27, 2008
Posts: 67
Hi guys,
Please help me out....

I have a jsp with a table. when I click on the "import to excel button" it has to create an excel sheet of the table. Currently I am doing it this way

create a string buffer and append the contents of the table to it
eg:
sbCsv.append( sPub + " " + sIssueMonth + " " + sIssueYear + " Forecast Report \n" );
sbCsv.append("Sales" + "\t" );
sbCsv.append("Ran Last Year" + "\t" );
sbCsv.append("Pages 100%-90%" + "\t" );
sbCsv.append("Pages 75%" + "\t" );
sbCsv.append("Pages 50%" + "\t" );
sbCsv.append("Pages 25%" + "\t" );
sbCsv.append("Forecast" + "\t" );
sbCsv.append("Forecast Last Week" + "\t" );
sbCsv.append("\n");

Then writing this to the excel sheet. Is there a better way to do it ???
Amit Ghorpade
Bartender

Joined: Jun 06, 2007
Posts: 2709
    
    5

This topic has been discussed before
try searching the forum and
check this.

Hope this helps


SCJP, SCWCD.
|Asking Good Questions|
Sahana Hegde
Ranch Hand

Joined: Jan 27, 2008
Posts: 67
Yes that helped.....tried something on similar lines.
Thanks. I appreciate it.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: JSP to Excel sheet
 
Similar Threads
Java and Excel
Create table in Excel
Generating Insert Script from Excel sheet
handling excel sheet with java
Exporting HTML-Table data to EXCEL sheet