问题描述
我正在尝试从我的 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)