SpringBoot实现数据导出

pom依赖：

<dependency>
	<groupId>org.apache.poi</groupId>
    <artifactId>poi</artifactId>
    <version>3.14</version>
</dependency>
<dependency>
	<groupId>org.apache.poi</groupId>
	<artifactId>poi-ooxml-schemas</artifactId>
	<version>3.14</version>
</dependency>
<dependency>
	<groupId>org.apache.poi</groupId>
	<artifactId>poi-ooxml</artifactId>
	<version>3.14</version>
</dependency>

HTML5 代码：

<a th:class="${active == '/uploadExcel.html'?'nav-link active':'nav-link'}" th:href="@{/admin/exportData}">导出学生信息</a>

service实现类代码

@Override
    public XSSFWorkbook exportData(HttpServletResponse response) {
        List<Student> students = studentDao.findAll();
        XSSFWorkbook wb = new XSSFWorkbook();
        //创建一张表
        Sheet sheet = wb.createSheet("Student");
        //创建第一行，起始为0
        Row titleRow = sheet.createRow(0);
        //第一列
        titleRow.createCell(0).setCellValue("序号");
        //第二列
        titleRow.createCell(1).setCellValue("学号");
        //第三列
        titleRow.createCell(2).setCellValue("姓名");
        //第四列
        titleRow.createCell(3).setCellValue("身份证");
        //第五列
        titleRow.createCell(4).setCellValue("年龄");
        //第六列
        titleRow.createCell(5).setCellValue("地址");
        //序号，默认为1
        int cell = 1;
        //遍历
        for (Student student : students) {
            //第一行保存的是每一列的列名
            //从第二行开始保存数据
            Row row = sheet.createRow(cell);
            //第一列 序号
            row.createCell(0).setCellValue(cell);
            //将数据库的数据遍历出来
            //第二列 学号
            row.createCell(1).setCellValue(student.getId());
            //第三列 姓名
            row.createCell(2).setCellValue(student.getName());
            //第四列 身份证
            row.createCell(3).setCellValue(student.getIdCard());
            //第五列 年龄
            row.createCell(4).setCellValue(student.getAge());
            //第六列 地址
            row.createCell(5).setCellValue(student.getAddress());
            //序号自增
            cell++;
        }
        //设置文档名称，这儿写死了，也可以前端传输（前端传一个文件名到后端就行）
        String fileName = "学生信息表.xlsx";
        OutputStream outputStream =null;
        try {
            //文件名编码格式
            fileName = URLEncoder.encode(fileName,"UTF-8");
            //设置ContentType请求信息格式
            response.setContentType("application/vnd.ms-excel");
            //设置标头
            response.setHeader("Content-disposition", "attachment;filename=" + fileName);
            outputStream = response.getOutputStream();
            wb.write(outputStream);
        } catch (UnsupportedEncodingException e) {
            e.printStackTrace();
        } catch (IOException e) {
            e.printStackTrace();
        }finally {
            try {
                outputStream.flush();
                outputStream.close();
            } catch (IOException e) {
                e.printStackTrace();
            }
        }
        return wb;
    }

controller层代码：

@GetMapping("/exportData")
    public void exportData(HttpServletResponse response){
        studentService.exportData(response);
    }