Spring Boot 使用 Apache Commons CSV 导出 CSV 文件

依赖

<dependency>
    <groupId>org.apache.commons</groupId>
    <artifactId>commons-csv</artifactId>
    <version>1.14.1</version>
</dependency>

代码

@GetMapping("/api/export")
public void export(ExportRequest request, HttpServletResponse response) throws IOException {
    CSVFormat csvFormat = CSVFormat.DEFAULT.builder().setHeader("id", "HeaderA", "HeaderB", "HeaderC").get();
    List<XXX> list = listMapper.export(request);
    try (
            OutputStreamWriter writer = new OutputStreamWriter(response.getOutputStream(), StandardCharsets.UTF_8);
            CSVPrinter printer = new CSVPrinter(writer, csvFormat)
    ) {
        response.setCharacterEncoding(StandardCharsets.UTF_8);
        response.setContentType(MediaType.APPLICATION_OCTET_STREAM_VALUE);
        response.setHeader("Content-Disposition", "attachment;filename=file.csv");

        response.getOutputStream().write(0xEF);
        response.getOutputStream().write(0xBB);
        response.getOutputStream().write(0xBF);


        for (XXX e : list) {
            printer.printRecord(
                    e.getId(),
                    e.getHeadA(),
                    e.getHeadB(),
                    e.getHeadC(),
            );
        }
        printer.flush();
    }
}

文档

https://commons.apache.org/proper/commons-csv/