0
异常代码
//获取报表的开始时间和结束时间
log.info("开始时间:"+startDay);
log.info("结束时间:"+endDay);
//查询数据
List<ExcelDTO> list = tbGarbageBuyService.queryReport(startDay,endDay);
ExcelWriter writer = null;
OutputStream outputStream = response.getOutputStream();
long startTime=System.currentTimeMillis();
try {
String fileName = URLEncoder.encode("测试", "UTF-8");
//添加响应头信息
response.setHeader("Content-disposition", "attachment; filename=" + fileName+".xlsx");
response.setContentType("application/msexcel;charset=UTF-8");//设置类型
response.setHeader("Pragma", "No-cache");//设置头
response.setHeader("Cache-Control", "no-cache");//设置头
response.setDateHeader("Expires", 0);//设置日期头
//实例化 ExcelWriter
writer = new ExcelWriter(outputStream, ExcelTypeEnum.XLSX, true);
//实例化表单
Sheet sheet = new Sheet(1, 0, ExcelDTO1.class);
sheet.setSheetName("统计表");
//获取数据
log.info("查询时间:{}s.条数:{}",(float)(System.currentTimeMillis()-startTime)/1000,list.size());
startTime=System.currentTimeMillis();
//输出
writer.write(list, sheet);
writer.finish();
outputStream.flush();
} catch (IOException e) {
log.info("导出异常",e);
} finally {
try {
response.getOutputStream().close();
} catch (IOException e) {
log.info("导出异常",e);
}
}
log.info("导出:{}s",(float)(System.currentTimeMillis()-startTime)/1000);