Hey Dave, thanks for the prompt answer. 1) Servlet-based response being flushed back, not a JSP. 2) yeah, we figure it's the proxy setup...we're trying different things as we speak. 3) Weblogic app server, and apache web server
I just wanted to see if I needed to add more code to the way I am writing the answer back, encoding type etc? Will keep u posted if we get to a good or kludgy solution, walid -----Original Message----- From: David Fisher [mailto:[email protected]] Sent: Tuesday, June 01, 2010 3:54 PM To: POI Users List Subject: Re: excel does not open with reverse proxy setup Hi Walid, > Excel POI had been working great for us, the printing with an excel > template etc...until we implemented a reverse proxy pattern to prohibit > users from directly accessing our app, and sending back to a global > logon page first. This is likely to have to do with how your proxy is configured. > We now get this error: > > HTTP/1.1 200 OK date: Tue, 01 Jun 2010 19:16:30 GMT transfer-encoding: > chunked content-type: application/vnd.ms-excel content-disposition: > attachment; filename=EG.xlsx" X-Powered-By: Servlet/2.5 JSP/2.1 > > Using XSSF with this setup when we write out the response back to the > server: > > response.setContentType("application/vnd.ms-excel"); > response.setHeader("Content-Disposition", "attachment; filename=" + > EXCEL_FILENAME + "\""); What happens when if you take POI out of the flow and just read an XLSX from disk and write it to the response? I assume from your fragment that you are in a JSP? It can be problematic to serve a non-text file format like xls or xlsx from a JSP, a servlet is recommended. One reason is that it can be easy to insert a carriage return into the file depending on your squiggly brackets in the JSP. Also, check to see if your proxy is "gzipping" the contents. Beyond this you will likely need to discuss the issue with the proxy vendor or your Servlet platform. You don't tell us what these are so I can't think of any other tips. Regards, Dave > > > > Any help is appreciated - thx, walid > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
