That didn't do it either but thanks for trying. Jody
"Tahir Akhtar" <[EMAIL PROTECTED]> 03/08/2006 01:07 PM Please respond to "POI Users List" <[email protected]> To "'POI Users List'" <[email protected]> cc Subject RE: Excel Sheet Title You can also try setting content type to application/octet-stream . This helps in many cases. I used it for downloading csv files and it worked correctly in latest version of both IE and Firefox. Regards, Tahir -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 08, 2006 10:32 PM To: POI Users List Subject: RE: Excel Sheet Title Thank you. I did read it. But it only deals with effectively downloading a file. When I use that, I get a save dialog with an unknown filetype in I.E. (it works better in Firefox), no view dialog, like I want. If I use: response.setContentType("application/vnd.ms-excel"); response.setHeader("Content-Disposition", "attachment; filename=" + filename); I get a view dialog but the header doesn't take in I.E. Maybe I will not be able to do this? Jody "Tahir Akhtar" <[EMAIL PROTECTED]> 03/08/2006 12:12 PM Please respond to "POI Users List" <[email protected]> To "'POI Users List'" <[email protected]> cc Subject RE: Excel Sheet Title Jody, I recommend you look into the tip at http://www.onjava.com/pub/a/onjava/excerpt/jebp_3/index3.html Not a long read. It explains the reason why the browsers behave strangely when handling downloads and offers some good suggestions. I remember it recommends using res.setContentType("application/x-download"); to avoid some common gotchas. Regards, Tahir -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 08, 2006 10:05 PM To: POI Users List Subject: RE: Excel Sheet Title I don't really want to save the file right away. I want to let the user view it and I want to specify the title and suggest the filename when they save it. This works in Firefox: response.setContentType("application/vnd.ms-excel"); response.setHeader("Content-Disposition", "attachment; filename=" + filename); But not IE. IE just show the servlet name as before. Thanks again. Jody "Tahir Akhtar" <[EMAIL PROTECTED]> 03/08/2006 10:04 AM Please respond to "POI Users List" <[email protected]> To "'POI Users List'" <[email protected]> cc Subject RE: Excel Sheet Title Jody, You need to set content-disposition header // Set the headers. res.setContentType("application/x-download"); res.setHeader("Content-Disposition", "attachment; filename=" + filename); For more details see http://www.onjava.com/pub/a/onjava/excerpt/jebp_3/index3.html Hope this helps. Regards, Tahir -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 08, 2006 7:53 PM To: [email protected] Subject: Excel Sheet Title Is there any way to change the default file save name and title when I create a spreadsheet? Right now it is the name and path of my servlet. That's totally not what I want. I searched and searched and could not find anything. Here's my code: In the servlet: private void displayBUSRxsl(BusrView busrView, int langId, int currId, HttpServletResponse response) throws Exception { try{ SRMCreateXls xls = new SRMCreateXls(); HSSFWorkbook wb = xls.createBUSRWorkbook(busrView, langId, currId); response.setContentType("application/vnd.ms-excel"); ServletOutputStream out = response.getOutputStream(); wb.write(out); out.write(wb.getBytes()); out.close(); } catch(Exception e){ throw new SRMException(e.getMessage()); } } Is it because I'm using a ServletOutputStream? The fileOutputStream lets you create a file name whereas the ServletOutputStream does not. And I don't see anything in POI that lets me name the file. Also, I want to set the column width for each column. Do I have to do that for each row? I have tried several variations of this and it seems the only way I can get it to work is to set the column width for each row. That seems like oeverkill to me so I'm thinking I'm just not doing it right. Another issue I have is that I can't set the column with: spreadsheet.setColumnWidth((short) (0), (short) 20); I have to use this formula. spreadsheet.setColumnWidth((short) (0), (short) ((50 * 8) / ((double) 1 / 10))); I played with just using a number for a long time before trying it just like the example. Is this for real or am I missing something? And while I'm here, why are my error messages always empty? Thanks for any suggestions or observations. Jody -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.375 / Virus Database: 268.2.0/276 - Release Date: 3/7/2006 -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.375 / Virus Database: 268.2.0/276 - Release Date: 3/7/2006 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/ -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.375 / Virus Database: 268.2.0/276 - Release Date: 3/7/2006 -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.375 / Virus Database: 268.2.0/276 - Release Date: 3/7/2006 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/ -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.375 / Virus Database: 268.2.0/276 - Release Date: 3/7/2006 -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.375 / Virus Database: 268.2.0/276 - Release Date: 3/7/2006 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
