wood burning stoves 2.0*
The moose likes JSP and the fly likes Saving jsp output to a Excel File in different tabs Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Java » JSP
Bookmark "Saving jsp output to a Excel File in different tabs" Watch "Saving jsp output to a Excel File in different tabs" New topic
Author

Saving jsp output to a Excel File in different tabs

peter brews
Greenhorn

Joined: Feb 11, 2002
Posts: 20
Hi
I have a way of saving the output generated from a JSp file into to a excel file by modifiying the Headers. The code looks like this
String fname=abc.xls
response.setContentType("file_content_type);
response.setHeader("Content-disposition","attachment;filename="+fname)
The output is saved to a Excel file abc.xls
IT THERE A WAY TO SAVE THE OUTPUT IN DIFFERENT TABS IN THE EXCEL FILE.
For example : Output1 - to be saved in abx.xls on excel tab TAB1
Output2 - to be saved in abc.xls on excel tab TAB2
and so on
Please help me
Michael Zalewski
Ranch Hand

Joined: Jun 10, 2002
Posts: 30
You might want to check out
Jakarta POI
chanoch wiggers
Author
Ranch Hand

Joined: May 24, 2001
Posts: 245
that is absolutely fantastic, seriously - thanks for the tip. btw, a simpler method might be possible to implement using MIME? it might be that if you send multiple documents back it will pick them up seperately. CSV by itself does not have an automatic way to page contents, in which case you will need to look at an alternative. If you are not sure how to try this out, then it might be simpler to just learn POI because it would require some experimentation.


chanoch<p><a href="http://www.amazon.com/exec/obidos/ASIN/1861007736/" target="_blank" rel="nofollow">Author of Professional Apache Tomcat</a></p>
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Saving jsp output to a Excel File in different tabs
 
Similar Threads
Export data from Jsp to Excel taking more load time
postback model and AJAX
Locating Microsoft Excel executable
Saving JSP output to a File with extension .xls
Does anyone know how to export data from JSP to excel