Problem with rendering XLS Report

Hi all, 
 
I m trying to use the API which, on click of a button on screen, would render the report in as a excel sheet. Something that would give the user the option of opening or saving the sheet. (see attachment). 
 
When I use the following code : 
 
RenderOption renderOption = new RenderOption(); 
renderOption.setOutputFileName("test.xls"); 
renderOption.setOutputFormat("xls"); 
renderOption.setOutputStream(response.getOutputStream()); 
task.setRenderOption(renderOption); 
 
The file is generated on the server, but the user sees nothing on screen. 
 
When I changed the code as : 
 
RenderOption renderOption = new RenderOption(); 
renderOption.setOutputFormat("xls"); 
renderOption.setOutputStream(response.getOutputStream()); 
task.setRenderOption(renderOption); 
 
The entire XML output is shown in the browser but no xls.

I m sure its not a big issue, but somehow i m not able to get this. 
 
I m using Eclipse 3.4 BIRT 2.3. 
 
Please help with the code. 
 
Thanks 
Nikhil

Find more posts tagged with

Comments

ndesai

Adding - 
 
response.setContentType("application/vnd.ms-excel"); 
response.setHeader("Content-disposition","attachment;filename=Report.xls"); 
 
did the trick ! 
 
Cheers 
Nikhil