使用ServerWebExchange后进行数据导出excel/scv

最新推荐文章于 2024-01-19 10:14:56 发布

不敲代码的人会死亡

最新推荐文章于 2024-01-19 10:14:56 发布

阅读量347

点赞数

文章标签： excel java 服务器

本文链接：https://blog.csdn.net/weixin_43866048/article/details/131590671

版权

String[] CSV_HEADER = new String[] {
            "基地帐号", "基地名称", "基地简称", "基地类型", "门户编码", "省份", "城市", "下属企业租户数", "描述", "创建时间", "time"
        };


try (ByteArrayOutputStream outputStream = new ByteArrayOutputStream();
            OutputStreamWriter outputStreamWriter = new OutputStreamWriter(outputStream, Charset.forName("GBK"));
            CSVWriter csvWriter = new CSVWriter(outputStreamWriter, CSVWriter.DEFAULT_SEPARATOR,
                CSVWriter.NO_QUOTE_CHARACTER, CSVWriter.NO_ESCAPE_CHARACTER, CSVWriter.DEFAULT_LINE_END)) {
            csvWriter.writeNext(CSV_HEADER, false);
            // 写入数据   toArrayString方法自己创建
//            data.forEach(model -> csvWriter.writeNext(model.toArrayString(), false));
            csvWriter.flush();
            return ResponseEntity.ok()
                .header(HttpHeaders.CONTENT_DISPOSITION, "attachment; filename=" + "enterprise.csv")
                .contentType(MediaType.APPLICATION_OCTET_STREAM)
                .body(outputStream.toByteArray());
        } catch (IOException e) {
            throw new RuntimeException(e);
        }