hutool excelWriter.merge() 报错java.lang.IllegalArgumentException: Attempting to write a row[2] in the

报错内容：

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