alibaba / easyexcel

快速、简洁、解决大文件内存溢出的java处理Excel工具
https://easyexcel.opensource.alibaba.com
Apache License 2.0
32.09k stars 7.5k forks source link

单元格自定义格式转化成字符串错乱 #3895

Closed ILLU510N closed 2 months ago

ILLU510N commented 2 months ago

触发场景描述

单元格中使用了自定义格式,转化成的字符串和excel里查看的完全不一致 QQ_1721359420597 QQ_1721360096507 使用的是4.0.1版本。 使用不创建对象的Map<Integer, String>结果也一样

触发Bug的代码

@Setter
public class DemoData {
    @ExcelProperty("测试")
    public String string;

    @Override
    public String toString() {
        return "DemoData{" +
                "string='" + string + '\'' +
                '}';
    }
}

public class MyXlsReadListener2 implements ReadListener<DemoData> {

    @Override
    public void invoke(DemoData data, AnalysisContext context) {
        System.out.println(data);
    }

    @Override
    public void doAfterAllAnalysed(AnalysisContext context) {

    }
}

 public static void main(String[] args) {
        String fileName = TestFileUtil.getPath() + "test.xlsx";
        EasyExcel.read(fileName, new AnalysisEventListener<Map<Integer, String>>() {
            @Override
            public void invoke(Map<Integer, String> data, AnalysisContext context) {
                System.out.println(data);
            }
            @Override
            public void doAfterAllAnalysed(AnalysisContext context) {
            }
        }).sheet().doRead();
        EasyExcel.read(fileName, DemoData.class, new MyXlsReadListener2())
                .sheet().doRead();
    }

提示的异常或者没有达到的效果

psxjoy commented 2 months ago

Hi,有关时间的问题,你可以参考这个 issue 处理。

ILLU510N commented 2 months ago

感谢解答

psxjoy commented 2 months ago

This issue has been completed, I will close this issue.