spring html导出excel文件,Spring 导出 Excel-Fun言

Spring 4.3.7 导出Excel 方法,导出excel 使用的jar 为原生apache poi jar 文件

一开始网上找导出excel的方法，发现在Spring 的不同版本方法是不同的！

@RequestMapping(value="/exportExcel",method = RequestMethod.GET)

public AbstractExcelView exportExcel(HttpServletResponse response) {

String excelFileName = new SimpleDateFormat("yyyyMMddhhmmss").format(new Date()).toString();

response.reset();

response.setContentType("application/vnd.ms-excel");

response.setHeader("Content-disposition", "attachment; filename="+ excelFileName + ".xls");

try{

return new AbstractExcelView() {

@Override

protected void buildExcelDocument(Map arg0, HSSFWorkbook workbook, HttpServletRequest request,

HttpServletResponse response) throws Exception {

List list = UserService.selectAll(); // 查询数据库获取所有用户列表

addSheet(workbook.createSheet("Sheet1"), list);

}

/**

* 填充excel 方法 遍历List 填充 Sheet1

* @param sheet

* @param list

*/

private void addSheet(Sheet sheet, List list) {

int rowNum=0;

Row row0 = sheet.createRow(rowNum++);

row0.createCell(0).setCellValue("编号");

row0.createCell(1).setCellValue("名字");

for (User excel : list) {

Row row = sheet.createRow(rowNum++);

row.createCell(0).setCellValue(excel.getId());

row.createCell(1).setCellValue(excel.getName());

}

}

};

}catch(Exception e){

logger.error("导出excel错误", e);

return null;

}

}