[Bug] 在升级FastExcel从1.2.0到1.3.0后出现的，在处理多个sheet的Excel写入时发生了数组越界异常。

[yinzhiyu-hot]

Search before asking

• I searched in the issues and found nothing similar.

Fesod version

1.3.0

JDK version

1.8

Operating system

Windows 11

Steps To Reproduce

部分代码如下：

private static void writeExcelWithMultiSheet(ExcelWriter excelWriter, List<SheetConfig<?>> sheetDataList, int batchSize) {
//checkSheetConfigData(sheetDataList);

try {
    for (int sheetNo = 0, sheetDataListSize = sheetDataList.size(); sheetNo < sheetDataListSize; sheetNo++) {
        SheetConfig<?> sheetConfig = sheetDataList.get(sheetNo);
        String sheetName = sheetConfig.getSheetName();
        List dataList = sheetConfig.getDataList();
        Class<?> headClass = sheetConfig.getHeadClass();

        // 校验数据列表与表头类匹配性（包含空列表的处理）
        if (dataList.isEmpty()) {
            throw new IllegalArgumentException("数据列表不能为空");
        }
        if (!headClass.isAssignableFrom(dataList.get(0).getClass())) {
            throw new IllegalArgumentException("数据列表与表头类不匹配");
        }
        // 计算总批次数，向上取整（dataList非空，避免除零）
        int totalBatches = (dataList.size() + batchSize - 1) / batchSize;
        try {
            ExcelWriterSheetBuilder builder = FastExcel.writerSheet(sheetNo, sheetName);
            builderComponentRegister(builder);

            // 生成完整列头，支持多级表头
            List<List<String>> allHeaders = getAllHeaders(headClass, dataList);
            builder.head(allHeaders);
            WriteSheet writeSheet = builder.build();

            // 合并基础数据和动态数据
            List<List<Object>> mergedData = mergeDataWithField(headClass, dataList);

            writeData(excelWriter, writeSheet, mergedData, batchSize, totalBatches);
        } catch (Exception e) {
            log.error("写入Excel文件时发生异常，Sheet名称: {}", sheetName, e);
            throw e;
        }
    }
} finally {
    if (CLEAR.get()) {
        clear();
    }
}

}

private static void writeData(ExcelWriter excelWriter, WriteSheet writeSheet, List data, int batchSize, int totalBatches) {
if (ObjectUtil.isEmpty(data)) {
// 写入空文件数据
excelWriter.write(data, writeSheet);
} else {
for (int i = 0; i < data.size(); i += batchSize) {
// 当前批次加1
int currentBatch = (i / batchSize) + 1;
// 计算当前批次的结束索引，避免越界
int end = Math.min(i + batchSize, data.size());
// 获取当前批次的数据子集
List batchList = data.subList(i, end);
// 写入当前批次数据
excelWriter.write(batchList, writeSheet);

    }
} 

}

public static class SheetConfig {

/** Sheet名称 */
private final String sheetName;

/** 数据列表 */
private final List<T> dataList;

/** 表头类 */
private final Class<T> headClass;

/**
 * 构造函数，初始化Sheet配置信息
 * @remark 通过指定Sheet名称、数据列表和表头类来创建一个Sheet配置实例
 * @param sheetName  Sheet的名称
 * @param dataList   数据列表，包含要写入Sheet的数据
 * @param headClass  表头对应的Class类型，用于定义数据结构
 **/
public SheetConfig(String sheetName, List<T> dataList, Class<T> headClass) {
    this.sheetName = sheetName;
    this.dataList = dataList;
    this.headClass = headClass;
}

/**
 * 获取Sheet名称
 * @remark 返回当前Sheet配置的名称
 * @return String Sheet名称
 **/
public String getSheetName() {
    return sheetName;
}

/**
 * 获取数据列表
 * @remark 返回当前Sheet配置中的数据列表
 * @return List<T> 数据列表
 **/
public List<T> getDataList() {
    return dataList;
}

/**
 * 获取表头类
 * @remark 返回当前Sheet配置中定义的表头类
 * @return Class<T> 表头类
 **/
public Class<T> getHeadClass() {
    return headClass;
}

}

Current Behavior

Caused by: java.lang.ArrayIndexOutOfBoundsException: -1
at java.util.ArrayList.elementData(ArrayList.java:424)
at java.util.ArrayList.remove(ArrayList.java:501)
at org.apache.poi.xssf.usermodel.XSSFWorkbook.setSheetOrder(XSSFWorkbook.java:1736)
at org.apache.poi.xssf.streaming.SXSSFWorkbook.setSheetOrder(SXSSFWorkbook.java:623)
at cn.idev.excel.write.handler.impl.WriteSheetWorkbookWriteHandler.afterWorkbookDispose(WriteSheetWorkbookWriteHandler.java:48)
at cn.idev.excel.write.handler.WorkbookWriteHandler.afterWorkbookDispose(WorkbookWriteHandler.java:49)
at cn.idev.excel.write.handler.chain.WorkbookHandlerExecutionChain.afterWorkbookDispose(WorkbookHandlerExecutionChain.java:47)
at cn.idev.excel.write.handler.chain.WorkbookHandlerExecutionChain.afterWorkbookDispose(WorkbookHandlerExecutionChain.java:49)
at cn.idev.excel.util.WriteHandlerUtils.afterWorkbookDispose(WriteHandlerUtils.java:71)
at cn.idev.excel.context.WriteContextImpl.finish(WriteContextImpl.java:457)
at cn.idev.excel.write.ExcelBuilderImpl.finish(ExcelBuilderImpl.java:97)
at cn.idev.excel.ExcelWriter.finish(ExcelWriter.java:140)
at cn.idev.excel.ExcelWriter.close(ExcelWriter.java:155)
at cn.sample.base.common.utils.FastExcelUtils.writeExcelWithMultiSheet(FastExcelUtils.java:1369)

Expected Behavior

写入文件成功

Anything else?

No response

Are you willing to submit a PR?

• I'm willing to submit a PR!

[yinzhiyu-hot]

调试了一下，得到如图结果

[yinzhiyu-hot]

我将sheet名称缩短至最大31个字符，则正常写入，希望这些能提供一些参考价值

[yinzhiyu-hot]

继续调试，定位到是 poi 限制了31，与前面提及的最大31互相印证了，看来框架需要对此做一些注释进行阐述

[delei]

Hi, @yinzhiyu-hot
Thank you for your research on this issue. It seems that this is a limitation of the Apache POI or Excel itself?

[yinzhiyu-hot]

Yes

[delei]

Yes

Thanks. For now, we might optimize those document:

• Read: https://fesod.apache.org/docs/read/sheet/
• Write: https://fesod.apache.org/docs/write/sheet/

Are there any volunteers willing to submit a PR?

[yinzhiyu-hot]

感谢您这边的邀请，目前还在着重于当下，但期冀在未来为开源贡献一份绵薄之力。

[yinzhiyu-hot]

补充说明：1.2.0版本之所以没有问题，是由于并没有WriteSheetWorkbookWriteHandler的处理，这应该是1.3.0新增的吧！所以可能依然需要关注1.3.0版本的兼容性，我个人建议是将WriteSheetWorkbookWriteHandler的48行传入的sheetName按POI的31位截取后传入，并进行尝试，我本地自定义并注册MyWriteSheetWorkbookWriteHandler，且按31位截取传入后，并未报错，但由于依然执行了原来的WriteSheetWorkbookWriteHandler，最终无法真正印证心中所想，希望这些信息对后续的处理带来一定的参考价值。

[yinzhiyu-hot]

还是心有不甘，又做了进一步尝试，我在自定义的MyWriteSheetWorkbookWriteHandler 重写了afterWorkbookCreate并移除了默认的WriteSheetWorkbookWriteHandler，终于可以绕过默认的WriteSheetWorkbookWriteHandler，最终验证是可行的，成功写入，结果和1.2.0是一致的，大吉大利，今晚吃鸡！！！

[yinzhiyu-hot]

继续补充：经验证，并非只有处理多个sheet写入会发生越界，单一sheet一样存在。