使用POI技术实现excel文件导出功能

一.导入依赖

        <!--POI报表-->
        <dependency>
            <groupId>org.apache.poi</groupId>
            <artifactId>poi</artifactId>
            <version>3.14</version>
        </dependency>
        <dependency>
            <groupId>org.apache.poi</groupId>
            <artifactId>poi-ooxml</artifactId>
            <version>3.14</version>
        </dependency>

二.准备模板放到需要的路径下,如下放入resouces目录下

三.根据需求在对应的单元格填入代码

@GetMapping("/export")
public Result testPoi(HttpServletRequest request, HttpServletResponse 
response){
        PageResult blogPageResult = blogService.getBlogsForIndexPage(10);

        //基于提供的Excel模板文件在内存中创建一个Excel表格对象
String path=Thread.currentThread().getContextClassLoader().getResource("templates/report
_template.xlsx").getPath();


  XSSFWorkbook excel = new XSSFWorkbook(new FileInputStream(new File(path)));

   XSSFSheet sheet = excel.getSheetAt(0);

   XSSFRow row = sheet.getRow(2);
   row.getCell(5).setCellValue(DateUtil.format(new Date(),"yyyy-MM-dd"));//日期

   OutputStream out = response.getOutputStream();

   response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml
.sheet");
//代表的是Excel文件类型
   response.setHeader("Content-Disposition", "attachment;filename=report.xlsx");
//指定以附件形式进行下载
    excel.write(out);

    out.flush();
    out.close();
    excel.close();
    return null;
    }