easyExcel写Excel文件报错：Invalid row number (1048576) outside allowable range (0..1048575)

业务场景

10000多条数据集，每条数据包含经度、纬度等信息，计算每条数据两两间的距离，判断其3000米范围内的，将结果写入文件。

异常描述

java.lang.IllegalArgumentException: Invalid row number (1048576) outside allowable range (0..1048575)

	at org.apache.poi.xssf.streaming.SXSSFSheet.createRow(SXSSFSheet.java:123)
	at org.apache.poi.xssf.streaming.SXSSFSheet.createRow(SXSSFSheet.java:65)
	at com.alibaba.excel.util.WorkBookUtil.createRow(WorkBookUtil.java:90)
	at com.alibaba.excel.write.executor.ExcelWriteAddExecutor.addOneRowOfDataToExcel(ExcelWriteAddExecutor.java:71)
	at com.alibaba.excel.write.executor.ExcelWriteAddExecutor.add(ExcelWriteAddExecutor.java:58)
	at com.alibaba.excel.write.ExcelBuilderImpl.addContent(ExcelBuilderImpl.java:59)
	at com.alibaba.excel.ExcelWriter.write(ExcelWriter.java:73)
	at com.alibaba.excel.ExcelWriter.write(ExcelWriter.java:50)
	at com.chinamobile.zijin.sbasestationdistance.service.text.TextCalcService.processData(TextCalcService.java:90)
	at com.chinamobile.zijin.sbasestationdistance.listener.DataListener.doAfterAllAnalysed(DataListener.java:64)
	at com.alibaba.excel.read.processor.DefaultAnalysisEventProcessor.endSheet(DefaultAnalysisEventProcessor.java:62)
	at com.alibaba.excel.analysis.v07.XlsxSaxAnalyser.execute(XlsxSaxAnalyser.java:272)
	at com.alibaba.excel.analysis.ExcelAnalyserImpl.analysis(ExcelAnalyserImpl.java:124)
	at com.alibaba.excel.ExcelReader.read(ExcelReader.java:66)
	at com.alibaba.excel.ExcelReader.read(ExcelReader.java:56)
	at com.alibaba.excel.read.builder.ExcelReaderSheetBuilder.doRead(ExcelReaderSheetBuilder.java:65)

解决方式

写到不同的sheet 同一个对象

private int ALLOWABLE_ROW = 1048575;

try (ExcelWriter excelWriter = EasyExcel.write(fileName, LonLatResData.class).build()) {
……
// count为写入sheet表单中的数据量统计
// sheetNo当前写的表单
WriteSheet writeSheet = EasyExcel.writerSheet(sheetNo, "模板" + sheetNo).build();
                if (count > (sheetNo + 1) * ALLOWABLE_ROW) {
                    sheetNo++;
                    writeSheet = EasyExcel.writerSheet(sheetNo, "模板" + sheetNo).build();
                }
                excelWriter.write(resList, writeSheet);