Spring Boot 控制器导出 Excel

使用Spring Boot框架可以方便地实现控制器导出Excel功能。本文将介绍如何 ，并添加案例代码来说明这个功能的具体实现过程。

xml
    org.apache.poi
    poi
    4.1.2
    org.apache.poi
    poi-ooxml
    4.1.2

java
import org.apache.poi.ss.usermodel.*;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
@RestController
@RequestMapping("/excel")
public class ExcelController {
    @GetMapping("/export")
    public void exportExcel(HttpServletResponse response) throws IOException {
        // 创建Excel工作簿
        Workbook workbook = new XSSFWorkbook();
        // 创建一个工作表
        Sheet sheet = workbook.createSheet("用户列表");
        // 创建表头
        Row headerRow = sheet.createRow(0);
        Cell headerCell = headerRow.createCell(0);
        headerCell.setCellValue("姓名");
        // 填充数据
        Row dataRow = sheet.createRow(1);
        Cell dataCell = dataRow.createCell(0);
        dataCell.setCellValue("张三");
        // 设置响应头信息
        response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
        response.setHeader("Content-Disposition", "attachment; filename=userList.xlsx");
        // 将Excel写入响应流
        workbook.write(response.getOutputStream());
        // 关闭工作簿
        workbook.close();
    }
}