导出限制解决方法之一
String[] headers = { "项目名称", "楼栋名称", "单元名称", "楼层名称", "房间名称", "业主/租户姓名", "房间状态", "房间功能","认证人数" };
deriveUtils(headers, valueMap,"认证统计", response, request,null,null);
#导出方法
private void deriveUtils(String[] headers,Map<String, Object> valueMap, String xlsName, HttpServletResponse response, HttpServletRequest request, Object o, Object o1) throws IOException {
response.reset();
response.setContentType("application/vnd.ms-excel");
Integer date = DateUtil.getNowTime();// 当前时间
String fileName = xlsName + date + ".xls";
UploadUtil.setFileDownloadHeader(request, response, fileName);
List<Map<String, Object>> list = (List<Map<String, Object>>) valueMap.get("values");
HSSFWorkbook web = new HSSFWorkbook();// 建立新HSSFWorkbook对象
Integer count = li