you can specify the name -- the download path behaves diifferently depending on the browser(IE/Netscape-Mozilla)
the best you can get from download path is for it to remember the path that the open browser was downloaded to - note this varies from Netscape to IE we like to serialize download names - to force uniqueness - you can modify the name generation section with variables goodluck Kurt -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 08, 2006 9:24 AM To: POI Users List Subject: RE: Excel Sheet Title Yes that works. Thank you so much. 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/ --------------------------------------------------------------------- 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/
