Springboot生成Excel表格

1、在pom.xml中添加Excel的相关依赖包

<!--        Excel-->
        <dependency>
            <groupId>org.apache.poi</groupId>
            <artifactId>poi</artifactId>
            <version>4.1.2</version>
        </dependency>
        <dependency>
            <groupId>org.apache.poi</groupId>
            <artifactId>poi-ooxml</artifactId>
            <version>4.1.2</version>
        </dependency>

2、在Controller里写入相关数据

@ResponseBody
@RequestMapping("/carnjExport")
//将列表数据导出为Excel
public void carnjExport(HttpServletResponse response){
    try{
        //设置Excel表格信息
        XSSFWorkbook workbook=new XSSFWorkbook();