File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JSP and the fly likes Problem with exporting data from JSP to excel sheet Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Java » JSP
Bookmark "Problem with exporting data from JSP to excel sheet" Watch "Problem with exporting data from JSP to excel sheet" New topic
Author

Problem with exporting data from JSP to excel sheet

Karthik Vijayarajan
Ranch Hand

Joined: Mar 13, 2005
Posts: 43
Hi
I am trying to export data from my JSP to an excel sheet.
I used the following code in my JSP.


response.setContentType("application/vnd.ms-excel");
response.setHeader("Content-
disposition", "attachment;filename=ExcelAdjustments.xls");
response.setHeader("Pragma", "public");
response.setHeader("Cache-Control", "max-age=0");

It is working fine sometimes but at times it throws the following error.

Error 500: HTTP/1.1 408 Connection timed out while reading request Server: WebSphere Application Server/5.1 Content-Type: text/html Content-Length: 142 Connection: close

If i remove this,
response.setHeader("Cache-Control", "max-age=0"), i am able to save the excel without any error but i am not able to directly open the excel without saving it.


My browser is IE 5
Please advice.

Thanks
Karthik


Karthik <br />SCJP 1.4 SCWCD 1.4 SCBCD 1.3
 
GeeCON Prague 2014
 
subject: Problem with exporting data from JSP to excel sheet