Hi !
I have the following in my testapplication.xml
<action name="exportPlanToExcel" class="com.manageme.action.ExportToExcelAction">
<result name="success" type="stream">
<param name="contentType">application/vnd.ms-excel</param>
<param name="inputName">inputStream</param>
<param name="bufferSize">4096</param>
</result>
</action>
And the action class is as follows:
public class ExportToExcelAction extends ActionSupport implements ServletRequestAware,ServletResponseAware,SessionAware
{
........
........
public
String execute() throws Exception{
inputStream = getExcelInputStream();
return SUCCESS;
}
public InputStream getExcelInputStream() {
return new ByteArrayInputStream(exportExcel().toByteArray());
}
private ByteArrayOutputStream exportExcel() {
ByteArrayOutputStream bos = new ByteArrayOutputStream();
response.setHeader("Content-disposition", "attachment; filename=" + "MyFile.xls");
try {
WritableWorkbook workbook = Workbook.createWorkbook(bos);
WritableSheet sheet = workbook.createSheet("Contactos", 0);
WritableCellFormat textFormat = new WritableCellFormat(NumberFormats.TEXT);
//ADD STUFF TO SHEET
workbook.write();
workbook.close();
} catch (RowsExceededException e) {
e.printStackTrace();
} catch (WriteException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
return bos;
}
}
The following code does not give any error but the expected Save As / Open dialogue does not come up.
What may i be doing wrong?
Please help