java导出excel临时文件_请教大佬们，关于 Java 用 poi 的 SXSSFWorkbook 导出大量数据到 excel 文档，能否不生成临时文件，直接写入到响应流中呢...

goldpumpkin

265 天前

@fxxwor99LVHTing

@xuanbg

谢谢回复。其实我想要的是增量输出到 outputstream 里面，我试了一下，不得行。

```

try {

ServletResponse responseAsync = asyncContext.getResponse();

responseAsync.setCharacterEncoding("utf-8");

List> row = Arrays.asList(CollUtil.newArrayList("订单号", "渠道", "下班时间", "加班时长", "餐补", "车补次数", "车补", "总计"));

ExcelWriter excelWriter = ExcelUtil.getBigWriter();

excelWriter.write(row);

excelWriter.flush(responseAsync.getOutputStream());

responseAsync.getOutputStream().flush();

for (int i = 0; i < 10; i++) {

excelWriter.write(row);

excelWriter.flush(responseAsync.getOutputStream());

Thread.sleep(2000);

}

responseAsync.getOutputStream().flush();

} catch (Exception e) {

}

```