File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Export to excel - in Struts 2

 
Rohit Rai
Ranch Hand
Posts: 53
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
David Newton
Author
Rancher
Posts: 12617
IntelliJ IDE Ruby
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Please UseCodeTags.

What *does* happen?
 
jiggs ray
Greenhorn
Posts: 1
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Rohit,

It must have been long time since you posted it. By any chance do you have the solution for it.

Thanks
Jiggs
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic