EasyExcel在Windows和macOS导出数据没问题,在Linux上出问题

101 阅读1分钟

问题

EasyExcel在Windows和macOS导出数据没问题,可是在Linux上就会出现空指针报错

EasyExcel.write(file, DataTemp.class)
        .excelType(ExcelTypeEnum.XLSX)
        .registerWriteHandler(getDefaultWriteHandler())
        .registerWriteHandler(new ExcelCellWidthStyleStrategy())
        .registerConverter(new DateStringConverter())
        .registerConverter(new BigDecimalStringConverter())
        .sheet("测试")
        .doWrite(dataList);

解决

如果数据量不大的情况下,可以用内存运行

EasyExcel.write(file, DataTemp.class)
        .excelType(ExcelTypeEnum.XLSX)
        .inMemory(Boolean.TRUE)
        .registerWriteHandler(getDefaultWriteHandler())
        .registerWriteHandler(new ExcelCellWidthStyleStrategy())
        .registerConverter(new DateStringConverter())
        .registerConverter(new BigDecimalStringConverter())
        .sheet("测试")
        .doWrite(dataList);