关于在Action里导出Excel

Question

我用字节流导出Excel，请问哪位大师有相关的例子

Answer 1

把要导出的excel转成文件流用out对象输出就可以了。下面是我的一个例子response.setContentType("application/vnd.ms-excel;charset=uft-8"); 
response.setHeader("Content-Disposition","attachment; filename=" + fileName); 
OutputStream outStream = new FileOutputStream(file);
HSSFWorkbook book = productService.exportExcel(productIds, filedCodes, MzfEntity.PRODUCT, outStream);
outStream.write(book.getBytes());
outStream.flush();

Answer 2

@Results({@Result(name = "export",type = "stream",params = 
{"contentType","application/octet-stream;charset=UTF-8",
"contentDisposition","attachment;filename=\"Excel.xls\"",
"inputName","exportFile"})})
public class TestAction extends ActionSupport {
 private InputStream exportFile; public String export() {
  exportFile = {获取你的Excel文件流};
  return "export";
 } public InputStream getExportFile() {
  return exportFile;
 }
}
访问 test!export.action

Answer 3

其实可以不用这么麻烦的 可以直接用jsp导出  只需要在jsp页面上更改两个地方：
1：
<%@page contentType="application/vnd.ms-excel;charset=UTF-8" %>
2：
response.setHeader("Content-disposition","inline; filename=test1.xls");