easyUI-datagrid导出功能实现：服务与控制器示例

@RequestMapping(value = "/exporterExcel")
@ResponseBody
public void exportData( HttpServletResponse response,String lunci,String creatTimeX,String creatTimeY) throws Exception {
List<String> header = new ArrayList<>();
List<String> methodNames = new ArrayList<>();
List<BugInfoForDevelop> result =bugInfoForDevelopService.getAll(lunci, creatTimeX, creatTimeY);

header.addAll(Arrays.asList(new String[]{"开发人员", "缺陷总数", "致命缺陷", "严重缺陷", "一般缺陷", "微小缺陷", "建议缺陷","已确认","已分配","已修复","重新打开","已挂起","致命缺陷","严重缺陷","一般缺陷"}));

methodNames.addAll(Arrays.asList(new String[]{"getDeveloperName", "getBugCount", "getZhiming", "getYanzhong", "getYiban", "getWeixiao", "getJianyi","getQuerenY","getFenpeiY","getXiufuY","getReOpen","getGuaqiY","getZhiming3","getYanzhong3","getYiban3"}));

StatementExport.export(response, header, methodNames, result, null);

}



public static void export(HttpServletResponse response, List<String> header, List<String> methodNames, List rows, String fileName) throws Exception {

if(response == null || response.isCommitted()) {

throw new Exception("响应已经关闭，或者响应为空！");

}

if(header == null) {

throw new Exception("表头不能为null");

}

if(methodNames == null) {

throw new Exception("数据对应方法名不能为null");

}

if(rows == null) {

throw new Exception("数据不能为null");

}

if(fileName == null) {

fileName = "statement.xls";

}
// 设置返回response头
try {
fileName = new String(fileName.getBytes("UTF-8"), "ISO8859-1");
response.setContentType(ContextLoader.getCurrentWebApplicationContext().getServletContext().getMimeType(fileName));
response.setHeader("Content-Disposition", "attachment;filename=" + fileName);
} catch (UnsupportedEncodingException e1) {
e1.printStackTrace();
}

HSSFWorkbook workbook = new HSSFWorkbook();

HSSFSheet sheet = null;