hutool导出CSV文件

hutool导出CSV文件参考代码:

@PostMapping("/export")
public ResponseEntity<FileSystemResource> export() throws IOException {
// 写到临时目录,如果临时目录满了系统会自动清除。
File distFile = new File(System.getProperty("java.io.tmpdir"), "test.csv");
  // 创建CSV写入器,使用GBK编码格式,防止出现各个CSV工具打开乱码
CsvWriter csvWriter = new CsvWriter(distFile, CharsetUtil.CHARSET_GBK);
csvWriter.writeHeaderLine("策略id", "账户id");
List<List<Long>> rowList = new ArrayList<>();
rowList.add(Arrays.asList(111L, 222L));
rowList.add(Arrays.asList(333L, 444L));
rowList.add(Arrays.asList(555L, 666L));
csvWriter.write(rowList);
csvWriter.close();
final FileSystemResource fsr = new FileSystemResource(distFile);
return ResponseEntity.status(HttpStatus.OK)
.header("Content-disposition", "attachment;filename=test.csv")
.contentType(MediaType.APPLICATION_OCTET_STREAM)
.contentLength(fsr.contentLength())
.body(fsr);
}
如有问题请指出,THS!
posted on 2024-03-05 22:03  leecon666  阅读(1325)  评论(0)    收藏  举报