报错内容:

java.lang.IllegalArgumentException: Attempting to write a row[2] in the range [0,11] that is already written to disk.
	at org.apache.poi.xssf.streaming.SXSSFSheet.createRow(SXSSFSheet.java:138)
	at org.apache.poi.xssf.streaming.SXSSFSheet.createRow(SXSSFSheet.java:65)
	at org.apache.poi.ss.util.CellUtil.getRow(CellUtil.java:135)
	at org.apache.poi.ss.util.RegionUtil.setBorderLeft(RegionUtil.java:75)
	at cn.hutool.poi.excel.cell.CellUtil.mergingCells(CellUtil.java:342)
	at cn.hutool.poi.excel.ExcelWriter.merge(ExcelWriter.java:761)
	at cn.hutool.poi.excel.ExcelWriter.merge(ExcelWriter.java:742)

原因分析:

hutool 分批写入临时文件,默认写入批次大小为100条一次,所以当数据超过100条,并且需要合并单元格时,会报错

解决办法:

使用方法,初始化write即可

public BigExcelWriter(int rowAccessWindowSize) {
   this(WorkbookUtil.createSXSSFBook(rowAccessWindowSize), null);
}

参考地址: hutool导出excel合并单元格后导出数据报错 · Issue #I40N4W · dromara/hutool - Gitee.com

Logo

技术共进,成长同行——讯飞AI开发者社区

更多推荐