v7.2.2 文件保存报错

Wilson.Zhang

本帖最后由 Wilson.Zhang 于 2025-4-24 15:27 编辑

产品：GcExcel
版本：7.2.2
调研编号：DOCXLS-12193
Last Review：2025-04-24
当前进展：计划在8.1.1版本修复，临时解决方案为在保存前执行计算。

文件保存报错

public static void main(String[] args) {
String path = "L:\\下载文件\\1101-0001-0001-交易性金融资产明细表-中科铜箔.xlsx";
FileOutputStream fos = null;
try {
      Workbook workbook = new Workbook();
      workbook.open(path);

      fos = new FileOutputStream(path);
      workbook.save(fos);
} catch (Exception e) {
      e.printStackTrace();
} finally {
      if (null != fos) {
         try {
            fos.close();
         } catch (Exception var2) {
         }
      }
}
}

java.lang.NullPointerException: null
      at com.grapecity.documents.excel.n.q.a(Unknown Source) ~[gcexcel-7.2.2.jar:?]
      at com.grapecity.documents.excel.n.p.b(Unknown Source) ~[gcexcel-7.2.2.jar:?]
      at com.grapecity.documents.excel.n.p.a(Unknown Source) ~[gcexcel-7.2.2.jar:?]
      at com.grapecity.documents.excel.n.p.a(Unknown Source) ~[gcexcel-7.2.2.jar:?]
      at com.grapecity.documents.excel.j.p.c(Unknown Source) ~[gcexcel-7.2.2.jar:?]
      at com.grapecity.documents.excel.j.p.g(Unknown Source) ~[gcexcel-7.2.2.jar:?]
      at com.grapecity.documents.excel.j.k.o(Unknown Source) ~[gcexcel-7.2.2.jar:?]
      at com.grapecity.documents.excel.r.c.y.<init>(Unknown Source) ~[gcexcel-7.2.2.jar:?]
      at com.grapecity.documents.excel.r.c.aB.a(Unknown Source) ~[gcexcel-7.2.2.jar:?]
      at com.grapecity.documents.excel.r.c.M.a(Unknown Source) [gcexcel-7.2.2.jar:?]
      at com.grapecity.documents.excel.Workbook.a(Unknown Source) [gcexcel-7.2.2.jar:?]
      at com.grapecity.documents.excel.Workbook.save(Unknown Source) [gcexcel-7.2.2.jar:?]
      at cn.com.bdo.dgCenter.service.GcExcelService.main(GcExcelService.java:4611) [classes/:?]
java.lang.IllegalArgumentException: java.lang.NullPointerException
      at com.grapecity.documents.excel.r.c.M.a(Unknown Source)
      at com.grapecity.documents.excel.Workbook.a(Unknown Source)
      at com.grapecity.documents.excel.Workbook.save(Unknown Source)
      at cn.com.bdo.dgCenter.service.GcExcelService.main(GcExcelService.java:4611)
Caused by: java.lang.NullPointerException
      at com.grapecity.documents.excel.n.q.a(Unknown Source)
      at com.grapecity.documents.excel.n.p.b(Unknown Source)
      at com.grapecity.documents.excel.n.p.a(Unknown Source)
      at com.grapecity.documents.excel.n.p.a(Unknown Source)
      at com.grapecity.documents.excel.j.p.c(Unknown Source)
      at com.grapecity.documents.excel.j.p.g(Unknown Source)
      at com.grapecity.documents.excel.j.k.o(Unknown Source)
      at com.grapecity.documents.excel.r.c.y.<init>(Unknown Source)
      at com.grapecity.documents.excel.r.c.aB.a(Unknown Source)
      ... 4 more
Disconnected from the target VM, address: '127.0.0.1:50752', transport: 'socket'

Wilson.Zhang · Wilson.Zhang

您好！使用您提供的xlsx文件复现了问题，调研编号为DOCXLS-12193，调研后向您同步结论，请您耐心等候。

Wilson.Zhang · Wilson.Zhang

您好！初步排查似乎是引用错误，正在进一步调研。在Workbook:save()前通过Workbook:calculate()执行计算，可以正常保存，您可以以此为临时解决方案。待有结论再向您同步。

jin.ye · jin.ye

本帖最后由 jin.ye 于 2025-4-9 10:36 编辑

Wilson.Zhang 发表于 2025-4-8 08:47
您好！初步排查似乎是引用错误，正在进一步调研。在Workbook:save()前通过Workbook:calculate()执行计算， ...

麻烦看下这个文件保存报错是什么原因

哪个公式有问题

Wilson.Zhang · Wilson.Zhang

jin.ye 发表于 2025-4-9 10:35
麻烦看下这个文件保存报错是什么原因

了解您的问题了，正在对您最新提供的文件调研，待有结论后向您反馈。

同样在Workbook:calculate()重新计算后即可正常保存，您可以以此为临时解决方案。

		自动登录	找回密码
密码			立即注册

[调研中] v7.2.2 文件保存报错

评分

4 个回复