如何在Struts2结果中返回excel? [英] how to return excel in Struts2 result?
问题描述
我正在尝试从struts2操作类返回Excel工作表。
I am trying to return an Excel sheet from my struts2 action class.
我不确定应该使用哪种结果类型?有没有人试图从struts2动作类返回一个excel?
我希望用户看到打开/保存/取消对话框
I am not sure what result-type should I be using? Has anyone tried to return an excel from struts2 action class?
I would like the user to be presented with open/save/cancel dialog box
推荐答案
Omnipresent涵盖了struts.xml中的所需内容。我也在使用Action添加一个示例:
Omnipresent covered what you need in struts.xml. I'm adding an example with the Action as well:
InputStream excelStream
String contentDisposition
String documentFormat = "xlsx"
String excel() {
ServletContext servletContext = ServletActionContext.getServletContext()
String filePath = servletContext.getRealPath("/WEB-INF/template/excel/mytemplate.${documentFormat}")
File file = new File(filePath)
Workbook wb = WorkbookFactory.create(new FileInputStream(file))
Sheet sheet = wb.getSheetAt(0)
<write to excel file>
ByteArrayOutputStream baos = new ByteArrayOutputStream()
wb.write(baos)
excelStream = new ByteArrayInputStream(baos.toByteArray())
contentDisposition = "filename=\"myfilename.${documentFormat}\""
return SUCCESS
}
String getExcelContentType() {
return documentFormat == "xlsx" ? "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" : "application/vnd.ms-excel"
}
我正在使用poi模型:org.apache.poi.ss.usermodel。
I'm using the poi model: org.apache.poi.ss.usermodel.
您可以将xlsx替换为xls如果你愿意的话。
You can replace "xlsx" with "xls" if you want.
struts.xml:
struts.xml:
<action name="myaction" class="com.example.MyAction" method="excel">
<result type="stream">
<param name="contentType">${excelContentType}</param>
<param name="inputName">excelStream</param>
<param name="contentDisposition">contentDisposition</param>
<param name="bufferSize">1024</param>
</result>
</action>
(添加分号和翻译成有效Java的东西)
(add semicolons and stuff to translate to valid Java)
这篇关于如何在Struts2结果中返回excel?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!