[Bug] 1.3.0版本自定义的Converter找不到，1.2.0正常

[haoyang7]

Search before asking

• I searched in the issues and found nothing similar.

Fesod version

1.3.0

JDK version

17

Operating system

Centos7

Steps To Reproduce

!!!可能需要使用一个普通用户来启动jar包，使用root是正常的
try (ExcelWriter excelWriter = FastExcel.write(tempFile).excelType(ExcelTypeEnum.XLSX).build()) {
for (int i = 0; i < sheetNum; i++) {

                WriteSheet writeSheet = FastExcel.writerSheet(i, tableVo.getTableName() + "_" + (i + 1)).head(headList).build();
                for (int j = 0; j < idx; j++) {
                    List<List<Object>> dataList = new ArrayList<>();  
                    List<Map<String, Object>> data = demo();
                    if (CollectionUtil.isNotEmpty(data)) {
                        data.forEach(map -> {
                            List<Object> cellData = new ArrayList<>();
                            map.forEach((key, value) -> {
                                cellData.add(value);
                            });
                            dataList.add(cellData);
                        });

                        //写数据
                        excelWriter.write(dataList, writeSheet);
                        
                    }
                }
            }
        }

Current Behavior

org.apache.poi.xssf.streaming.SXSSFWorkbook - Failed to dispose sheet
java.io.IOException: Stream closed
at java.base/java.io.BufferedWriter.ensureOpen(BufferedWriter.java:107)
at java.base/java.io.BufferedWriter.write(BufferedWriter.java:224)
at java.base/java.io.Writer.write(Writer.java:249)
at org.apache.poi.xssf.streaming.SheetDataWriter.beginRow(SheetDataWriter.java:222)
at org.apache.poi.xssf.streaming.SheetDataWriter.writeRow(SheetDataWriter.java:212)
at org.apache.poi.xssf.streaming.SXSSFSheet.flushOneRow(SXSSFSheet.java:1963)
at org.apache.poi.xssf.streaming.SXSSFSheet.flushRows(SXSSFSheet.java:1928)
at org.apache.poi.xssf.streaming.SXSSFSheet.flushRows(SXSSFSheet.java:1941)
at org.apache.poi.xssf.streaming.SXSSFSheet.dispose(SXSSFSheet.java:1988)
at org.apache.poi.xssf.streaming.SXSSFWorkbook.dispose(SXSSFWorkbook.java:1025)
at org.apache.poi.xssf.streaming.SXSSFWorkbook.close(SXSSFWorkbook.java:934)
at cn.idev.excel.context.WriteContextImpl.finish(WriteContextImpl.java:481)
at cn.idev.excel.write.ExcelBuilderImpl.finish(ExcelBuilderImpl.java:97)
at cn.idev.excel.write.ExcelBuilderImpl.finishOnException(ExcelBuilderImpl.java:91)
at cn.idev.excel.write.ExcelBuilderImpl.addContent(ExcelBuilderImpl.java:59)
at cn.idev.excel.ExcelWriter.write(ExcelWriter.java:70)
at cn.idev.excel.ExcelWriter.write(ExcelWriter.java:47)

Expected Behavior

正常写入excel

Anything else?

No response

Are you willing to submit a PR?

• I'm willing to submit a PR!

[bengbengbalabalabeng]

环境

• Docker [CentOS 7]
• amazon-corretto-17
• fastexcel 1.3.0
• Maven 3.9.6

测试结果

正常，未复现普通用户执行错误问题。multi-sheet-pojo-write-test.xlsx 与以下结果一致。(是不是我这边遗漏了什么？)

代码

Main

public class App {
    public static void main(String[] args) {
        System.out.println("Hello World!");

        writeWithPOJO();

        writeWithNoPOJO();

        System.out.println("Done...");
    }

    static void writeWithPOJO() {
        String path = "/app/output/multi-sheet-pojo-write-test.xlsx";

        try (ExcelWriter excelWriter = FastExcel.write(path).excelType(ExcelTypeEnum.XLSX).build()) {
            for (int i = 0; i < 3; i++) {
                WriteSheet writeSheet = FastExcel.writerSheet(i, "TableName_" + (i + 1))
                        .head(ExcelData.class)
                        .build();

                excelWriter.write(pojoData(), writeSheet);
            }
        }
    }

    public static List<ExcelData> pojoData() {
        return IntStream.range(1, 11)
                .mapToObj(no -> new ExcelData(no, UUID.randomUUID().toString()))
                .toList();
    }

    @NoArgsConstructor
    @AllArgsConstructor
    @EqualsAndHashCode(callSuper = false)
    @Data
    public static class ExcelData implements Serializable {
        @ExcelProperty("序号")
        private Integer no;

        @ExcelProperty("代码")
        private String code;
    }

    static void writeWithNoPOJO() {
        String path = "/app/output/multi-sheet-list-write-test.xlsx";

        List<List<String>> head = new ArrayList<>();
        head.add(List.of("序号"));
        head.add(List.of("代码"));


        try (ExcelWriter excelWriter = FastExcel.write(path).excelType(ExcelTypeEnum.XLSX).build()) {
            for (int i = 0; i < 3; i++) {
                WriteSheet writeSheet = FastExcel.writerSheet(i, "TableName_" + (i + 1))
                        .head(head)
                        .build();

                excelWriter.write(mapData(), writeSheet);
            }
        }
    }

    public static List<List<Object>> mapData() {
        return IntStream.range(1, 11)
                .<List<Object>>mapToObj(no -> List.of(no, UUID.randomUUID().toString()))
                .toList();
    }
}

Dockerfile (By AI)

FROM centos:7

COPY amazon-corretto-17.0.17.10.1-linux-aarch64 /usr/lib/jvm/amazon-corretto-17

ENV JAVA_HOME=/usr/lib/jvm/amazon-corretto-17
ENV PATH="$JAVA_HOME/bin:${PATH}"

WORKDIR /app

COPY target/fesod-docker-test-1.0-SNAPSHOT-jar-with-dependencies.jar app.jar

# 创建非 root 用户（用于复现权限问题）
RUN useradd -m testuser
USER testuser

CMD ["java", "-jar", "app.jar"]

docker-compose.yaml (By AI)

version: "3.8"

services:
  fastexcel:
    build: .
    container_name: fesod-docker-test
    volumes:
      - {local-volume}:/app/output/
    working_dir: /app

[delei]

As temporary files need to be generated, I recommend verifying that non-root users possess permissions for the java.io.tmpdir directory.

[delei]

@haoyang7

BTW, Could you please provide the complete sample code? I noticed that you haven't included the code for the demo() method.

[haoyang7]

感谢大佬回复，我明天整理一下

[delei]

感谢大佬回复，我明天整理一下

Hi, @bengbengbalabalabeng
Welcome, would you be willing to continue following up on this issue? If possible, we could assign this issue to you.

[haoyang7]

定位到了，使用了spring的异步线程，异常日志被吞掉了，日志是这样的
Exception in thread "main" cn.idev.excel.exception.ExcelWriteDataConvertException: Can not find 'Converter' support class Timestamp.
at cn.idev.excel.write.executor.AbstractExcelWriteExecutor.doConvert(AbstractExcelWriteExecutor.java:339)
at cn.idev.excel.write.executor.AbstractExcelWriteExecutor.convert(AbstractExcelWriteExecutor.java:287)
at cn.idev.excel.write.executor.AbstractExcelWriteExecutor.converterAndSet(AbstractExcelWriteExecutor.java:56)
at cn.idev.excel.write.executor.ExcelWriteAddExecutor.doAddBasicTypeToExcel(ExcelWriteAddExecutor.java:140)
at cn.idev.excel.write.executor.ExcelWriteAddExecutor.addBasicTypeToExcel(ExcelWriteAddExecutor.java:98)
at cn.idev.excel.write.executor.ExcelWriteAddExecutor.addOneRowOfDataToExcel(ExcelWriteAddExecutor.java:74)
at cn.idev.excel.write.executor.ExcelWriteAddExecutor.add(ExcelWriteAddExecutor.java:55)
at cn.idev.excel.write.ExcelBuilderImpl.addContent(ExcelBuilderImpl.java:57)
at cn.idev.excel.ExcelWriter.write(ExcelWriter.java:70)
at cn.idev.excel.ExcelWriter.write(ExcelWriter.java:47)
可能1.3.0版本修改了 #322 ，

public class App {
public static void main(String[] args) {
System.out.println("Hello World!");

    writeWithNoPOJO();

    System.out.println("Done...");
}

static void writeWithNoPOJO() {
    File path = new File("./multi-sheet-list-write-test.xlsx");

    List<List<String>> head = new ArrayList<>();
    head.add(List.of("序号"));
    head.add(List.of("代码"));
    head.add(List.of("时间"));

    try (ExcelWriter excelWriter = FastExcel.write(path).excelType(ExcelTypeEnum.XLSX).build()) {
        for (int i = 0; i < 3; i++) {
            WriteSheet writeSheet = FastExcel.writerSheet(i, "TableName_" + (i + 1))
                    .head(head)
                    .registerConverter(new TimestampConverter())
                    .build();
            excelWriter.write(mapData(), writeSheet);
        }
    }
}

public static List<List<Object>> mapData() {
    return IntStream.range(1, 11)
            .<List<Object>>mapToObj(no -> List.of(no, UUID.randomUUID().toString(), new Timestamp(System.currentTimeMillis())))
            .toList();
}

}
public class TimestampConverter implements Converter {

@Override
public Class<Timestamp> supportJavaTypeKey() {
    return Timestamp.class;
}

@Override
public CellDataTypeEnum supportExcelTypeKey() {
    return CellDataTypeEnum.STRING;
}

@Override
public WriteCellData<String> convertToExcelData(Timestamp timestamp, ExcelContentProperty contentProperty,
                                                GlobalConfiguration globalConfiguration) throws Exception {
    return new WriteCellData<String>(FastDateFormat.getInstance("yyyy-MM-dd").format(timestamp));
}

}

@delei @bengbengbalabalabeng

使用log4j2的异步日志打印爆栈
2025-10-30T01:48:38.734297Z Log4j2-TF-1-AsyncLogger[AsyncContext@6073f712]-1 ERROR An exception occurred processing Appender Console
org.apache.logging.log4j.core.appender.AppenderLoggingException: java.lang.StackOverflowError
at org.apache.logging.log4j.core.config.AppenderControl.tryCallAppender(AppenderControl.java:164)
at org.apache.logging.log4j.core.config.AppenderControl.callAppender0(AppenderControl.java:133)
at org.apache.logging.log4j.core.config.AppenderControl.callAppenderPreventRecursion(AppenderControl.java:124)
at org.apache.logging.log4j.core.config.AppenderControl.callAppender(AppenderControl.java:88)
at org.apache.logging.log4j.core.config.LoggerConfig.callAppenders(LoggerConfig.java:711)
at org.apache.logging.log4j.core.config.LoggerConfig.processLogEvent(LoggerConfig.java:669)
at org.apache.logging.log4j.core.config.LoggerConfig.log(LoggerConfig.java:645)
at org.apache.logging.log4j.core.config.LoggerConfig.logParent(LoggerConfig.java:702)
at org.apache.logging.log4j.core.config.LoggerConfig.processLogEvent(LoggerConfig.java:671)
at org.apache.logging.log4j.core.config.LoggerConfig.log(LoggerConfig.java:645)
at org.apache.logging.log4j.core.config.LoggerConfig.log(LoggerConfig.java:633)
at org.apache.logging.log4j.core.config.AwaitCompletionReliabilityStrategy.log(AwaitCompletionReliabilityStrategy.java:108)
at org.apache.logging.log4j.core.async.AsyncLogger.actualAsyncLog(AsyncLogger.java:568)
at org.apache.logging.log4j.core.async.RingBufferLogEvent.execute(RingBufferLogEvent.java:172)
at org.apache.logging.log4j.core.async.RingBufferLogEventHandler4.onEvent(RingBufferLogEventHandler4.java:54)
at org.apache.logging.log4j.core.async.RingBufferLogEventHandler4.onEvent(RingBufferLogEventHandler4.java:31)
at com.lmax.disruptor.BatchEventProcessor.processEvents(BatchEventProcessor.java:167)
at com.lmax.disruptor.BatchEventProcessor.run(BatchEventProcessor.java:122)
at java.base/java.lang.Thread.run(Thread.java:840)
Caused by: java.lang.StackOverflowError
at cn.idev.excel.write.metadata.style.WriteFont.hashCode(WriteFont.java:18)
at cn.idev.excel.write.metadata.style.WriteCellStyle.hashCode(WriteCellStyle.java:25)
at cn.idev.excel.write.style.HorizontalCellStyleStrategy.hashCode(HorizontalCellStyleStrategy.java:20)
at java.base/java.util.ArrayList.hashCodeRange(ArrayList.java:595)
at java.base/java.util.ArrayList.hashCode(ArrayList.java:582)
at cn.idev.excel.write.metadata.holder.AbstractWriteHolder.hashCode(AbstractWriteHolder.java:53)
at cn.idev.excel.write.metadata.holder.WriteWorkbookHolder.hashCode(WriteWorkbookHolder.java:48)
at cn.idev.excel.write.metadata.holder.WriteSheetHolder.hashCode(WriteSheetHolder.java:25)
at java.base/java.util.Objects.hashCode(Objects.java:103)
at java.base/java.util.HashMap$Node.hashCode(HashMap.java:299)
at java.base/java.util.AbstractMap.hashCode(AbstractMap.java:526)
at cn.idev.excel.write.metadata.holder.WriteWorkbookHolder.hashCode(WriteWorkbookHolder.java:48)
at cn.idev.excel.write.metadata.holder.WriteSheetHolder.hashCode(WriteSheetHolder.java:25)

[bengbengbalabalabeng]

@haoyang7

Try a temporary method to fix it first?
先尝试临时方法修复？

public static class TimestampConverter implements Converter<Timestamp> {
        @Override
        public Class<Timestamp> supportJavaTypeKey() {
            return Timestamp.class;
        }

        @Override
        public CellDataTypeEnum supportExcelTypeKey() {
            // FIXME: Temporarily return null
            return null;
        }

        @Override
        public WriteCellData<?> convertToExcelData(Timestamp timestamp, ExcelContentProperty contentProperty,
                                                   GlobalConfiguration globalConfiguration) throws Exception {
            return new WriteCellData<>(FastDateFormat.getInstance("yyyy-MM-dd").format(timestamp));
        }
    }

[haoyang7]

@bengbengbalabalabeng 好的谢谢

[bengbengbalabalabeng]

Hi, @bengbengbalabalabeng Welcome, would you be willing to continue following up on this issue? If possible, we could assign this issue to you.

Hi, @delei This issue has been closed as it duplicates #648.