XLS File

[2005 IR Help]

By: Luis Gustavo Buffa - lgbuffa

XLS File

2004-01-28 02:30

Hi,

I've been exporting files as xls format and when the "save as" dialog is opened, I wanna have my default file name...is it possible?

I'm using the code below:

 

JRXlsExporter exporter = new JRXlsExporter();

response.setContentType("application/msexcel");

response.setContentType("application/vnd.ms-excel");

exporter.setParameter(JRExporterParameter.JASPER_PRINT, jPrint);

exporter.setParameter(JRExporterParameter.OUTPUT_STREAM, baos);

 

exporter.exportReport();

 

byte[] bytes = null;

 

bytes = baos.toByteArray();

 

response.setContentLength(bytes.length);

 

ServletOutputStream ouputStream = response.getOutputStream();

ouputStream.write(bytes, 0, bytes.length);

ouputStream.flush();

ouputStream.close();

 

Thanks,

Gustavo

 

 

 

 

By: Gregory A. Swarthout - gswarthout

RE: XLS File

2004-01-28 07:42

response.setHeader("Content-disposition", "inline; filename=" + myFilename);

 

 

 

 

 

By: Chuck Deal - cdeal

RE: XLS File

2004-01-28 07:57

I've tried this method before, and I didn;t have any luck. Any thoughts as to why this might not work?

 

Reports are generated via a servlet in PDF format streamed to a new IE browser window.