作者:鹏63213 | 来源:互联网 | 2023-09-18 15:52
1.先把模板文件拉入到项目中2.GetMapping(exportBusinessReport)publicvoidexportBusinessReport(HttpServ
1.先把模板文件拉入到项目中
![](https://img2.php1.cn/3cdc5/3ce1/78c/521de7a4c3ec8559.png)
2.
@GetMapping("exportBusinessReport")
public void exportBusinessReport(HttpServletResponse response) throws Exception{//准备数据Map map=reportService.getBusinessReportData();//把数据写出到Excel文件//getClass()获取对象//getClassLoader()获取类加载器//getResource()//获取资源//getPath()//获取路径String path = this.getClass().getClassLoader().getResource("tempaltes").getPath();path = path.substring(1);//工作簿对象---“区别XSSFWorkbook对应的是xlsx格式的文件HSSFWorkbook对应的是xls格式的文件”XSSFWorkbook workbook = new XSSFWorkbook(path+"//report_template.xlsx");//获取到表XSSFSheet sheetAt = workbook.getSheetAt(0);//行对象----下标以0开始XSSFRow row2 = sheetAt.getRow(2);//单元格对象XSSFCell cell25 = row2.getCell(5);//报表日期日期赋值cell25.setCellValue(map.get("reportDate")+"");
//把文件送到用户端
response.setHeader("content-disposition","attachment;filename=report.xlsx");
ServletOutputStream os = response.getOutputStream();
workbook.write(os);
//释放资源
os.flush();
os.close();
workbook.close();
3.导出后:
![](https://img2.php1.cn/3cdc5/3ce1/78c/864b7bb4a4fcf74b.png)