导出数据量小可使用HSSFWorkbook,XSSFWorkbook要注意内存溢出问题
// 调用
try {
List<FormVo> list = (List<FormVo>) service.getReportList(pm,null);
XSSFWorkbook xssfWorkbook = this.service.exportExcel(list);
String fileName ="导出excel名称";
OutputStream ou = response.getOutputStream();
reportUtil.writeExecl1(xssfWorkbook, ou, response, fileName);
} catch (Exception e) {
e.printStackTrace();
}
//写入到excel
public void writeExecl1(XSSFWorkbook workbook,OutputStream out,HttpServletResponse response,String execlName) throws Exception{
//response.setContentType("application/application/octet-stream");
response.addHeader("Content-Disposition", "attachment;filename="+URLEncoder.encode(execlName,"UTF-8")+