给页面添加Excel导出功能:
public void setResponse(HttpServletResponse response, HSSFWorkbook workbook, String excelName){ try { if (response != null) { response.setContentType("application/vnd.ms-excel;charset=utf-8"); response.setHeader("Content-Disposition", "attachment;filename=\"" + new String((excelName + ".xls").getBytes("gb2312"), "ISO8859-1")); OutputStream out = response.getOutputStream(); workbook.write(out); out.close(); } }catch (IOException e){ e.printStackTrace(); }}