sp无法导入这个excel文件

jiqimao · jiqimao

你好，用maven的2.2.1实测，这个问题仍然没有解决。我看git上的2.2.1版本的note没说修复这个DOCXLS-1066.
错误信息如下：
java.lang.NullPointerException
at com.grapecity.documents.excel.g.v.a(Unknown Source)
at com.grapecity.documents.excel.k.j.z.c(Unknown Source)
at com.grapecity.documents.excel.f.h.e(Unknown Source)
at com.grapecity.documents.excel.j.k.e(Unknown Source)
at com.grapecity.documents.excel.f.a.h(Unknown Source)
at com.grapecity.documents.excel.k.f.e.a(Unknown Source)
at com.grapecity.documents.excel.f.j.c(Unknown Source)
at com.grapecity.documents.excel.j.k.c(Unknown Source)
at com.grapecity.documents.excel.f.a.f(Unknown Source)
at com.grapecity.documents.excel.k.i.a.c(Unknown Source)
at com.grapecity.documents.excel.j.k.c(Unknown Source)
at com.grapecity.documents.excel.f.a.f(Unknown Source)
at com.grapecity.documents.excel.k.i.a.c(Unknown Source)
at com.grapecity.documents.excel.j.k.c(Unknown Source)
at com.grapecity.documents.excel.f.a.f(Unknown Source)
at com.grapecity.documents.excel.k.i.a.c(Unknown Source)
at com.grapecity.documents.excel.j.k.c(Unknown Source)
at com.grapecity.documents.excel.f.a.f(Unknown Source)
at com.grapecity.documents.excel.k.i.a.c(Unknown Source)
at com.grapecity.documents.excel.j.k.c(Unknown Source)
at com.grapecity.documents.excel.f.a.f(Unknown Source)
at com.grapecity.documents.excel.k.i.a.c(Unknown Source)
at com.grapecity.documents.excel.f.h.a(Unknown Source)
at com.grapecity.documents.excel.j.k.a(Unknown Source)
at com.grapecity.documents.excel.j.f.b(Unknown Source)
at com.grapecity.documents.excel.j.h.a(Unknown Source)
at com.grapecity.documents.excel.g.d.b(Unknown Source)
at com.grapecity.documents.excel.g.d.a(Unknown Source)
at com.grapecity.documents.excel.g.v.r(Unknown Source)
at com.grapecity.documents.excel.f.bJ.C(Unknown Source)
at com.grapecity.documents.excel.f.j.c(Unknown Source)
at com.grapecity.documents.excel.j.k.c(Unknown Source)
at com.grapecity.documents.excel.f.a.f(Unknown Source)
at com.grapecity.documents.excel.k.i.a.c(Unknown Source)
at com.grapecity.documents.excel.j.k.c(Unknown Source)
at com.grapecity.documents.excel.f.a.f(Unknown Source)
at com.grapecity.documents.excel.k.i.a.c(Unknown Source)
at com.grapecity.documents.excel.j.k.c(Unknown Source)
at com.grapecity.documents.excel.f.a.f(Unknown Source)
at com.grapecity.documents.excel.k.i.a.c(Unknown Source)
at com.grapecity.documents.excel.j.k.c(Unknown Source)
at com.grapecity.documents.excel.f.a.f(Unknown Source)
at com.grapecity.documents.excel.k.i.a.c(Unknown Source)
at com.grapecity.documents.excel.j.k.c(Unknown Source)
at com.grapecity.documents.excel.f.a.f(Unknown Source)
at com.grapecity.documents.excel.k.i.a.c(Unknown Source)
at com.grapecity.documents.excel.f.h.a(Unknown Source)
at com.grapecity.documents.excel.j.k.a(Unknown Source)
at com.grapecity.documents.excel.j.f.b(Unknown Source)
at com.grapecity.documents.excel.j.h.a(Unknown Source)
at com.grapecity.documents.excel.g.d.b(Unknown Source)
at com.grapecity.documents.excel.g.d.a(Unknown Source)
at com.grapecity.documents.excel.g.v.r(Unknown Source)
at com.grapecity.documents.excel.f.bJ.C(Unknown Source)
at com.grapecity.documents.excel.f.j.c(Unknown Source)
at com.grapecity.documents.excel.j.k.c(Unknown Source)
at com.grapecity.documents.excel.f.a.f(Unknown Source)
at com.grapecity.documents.excel.k.i.a.c(Unknown Source)
at com.grapecity.documents.excel.j.k.c(Unknown Source)
at com.grapecity.documents.excel.f.a.f(Unknown Source)
at com.grapecity.documents.excel.k.i.a.c(Unknown Source)
at com.grapecity.documents.excel.j.k.c(Unknown Source)
at com.grapecity.documents.excel.f.a.f(Unknown Source)
at com.grapecity.documents.excel.k.i.a.c(Unknown Source)
at com.grapecity.documents.excel.j.k.c(Unknown Source)
at com.grapecity.documents.excel.f.a.f(Unknown Source)
at com.grapecity.documents.excel.k.i.a.c(Unknown Source)
at com.grapecity.documents.excel.j.k.c(Unknown Source)
at com.grapecity.documents.excel.f.a.f(Unknown Source)
at com.grapecity.documents.excel.k.i.a.c(Unknown Source)
at com.grapecity.documents.excel.f.h.a(Unknown Source)
at com.grapecity.documents.excel.j.k.a(Unknown Source)
at com.grapecity.documents.excel.j.f.b(Unknown Source)
at com.grapecity.documents.excel.j.h.a(Unknown Source)
at com.grapecity.documents.excel.g.k.c(Unknown Source)
at com.grapecity.documents.excel.g.f.a(Unknown Source)
at com.grapecity.documents.excel.y.ao.a(Unknown Source)
at com.grapecity.documents.excel.y.ao.d(Unknown Source)
at com.grapecity.documents.excel.y.ao.d(Unknown Source)
at com.grapecity.documents.excel.y.ao.b(Unknown Source)
at com.grapecity.documents.excel.l.b.L.a(Unknown Source)
at com.grapecity.documents.excel.l.b.L.a(Unknown Source)
at com.grapecity.documents.excel.l.b.K.a(Unknown Source)
at com.grapecity.documents.excel.l.b.K.a(Unknown Source)
at com.grapecity.documents.excel.Workbook.toJson(Unknown Source)
at Main40.importExcel(Main40.java:29)
at Main40.main(Main40.java:12)

也是在workbook.toJson();这一步报的异常

         Workbook workbook = new Workbook();
         File file = new File(filePath);
         FileInputStream fileInput = new FileInputStream(file);
         workbook.open(fileInput);
         ssjson = workbook.toJson();《===异常

jiqimao · jiqimao

请问有进展吗？都已经等了gcexcel升级2个版本了，我们已经很耐心等待了。现在客户怨言很大，这个表格和另外一个他们没办法用，我们也有压力，还请尽快帮我们解决啊。

jiqimao · jiqimao

请问有进展吗

Clark.Pan · Clark.Pan

知道怎么回事了，maven上传的版本有些问题，不是最新的2.2.1，最新的已经修复了，用我附件发给您的包再试一下

jiqimao · jiqimao

我测试了，确实可以导出ssjson文件，但是sp无法打开导出的ssjson文件，麻烦请帮我试试sp后告诉我如何才能让sp打开这个文件。这个文件大概4千多行，也不算非常巨大。谢谢

Clark.Pan · Clark.Pan

本帖最后由 ClarkPan 于 2019-7-5 11:49 编辑

虽然只有几千行数据，但是ssjson有300多M，Excel也有10多M。连GCExcel后端都需要27S才能加载这个ssjson，前端SpreadJS肯定无法导入。目前只能将问题报上去，让研发看看这个Excel里面设置了什么东西会导致这么大，再看看有没有办法去优化的。

jiqimao · jiqimao

那请帮我们看看究竟是什么东西导致这么巨大的，感谢你，能明确的话我们可以和客户商量进行相应的修改。

jiqimao · jiqimao

请问有进展吗

dexteryao · dexteryao

我看潘工已经提交研发了，开发那边有结论这边会立刻通知您的

jiqimao · jiqimao

7天过去了，有进展吗

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

sp无法导入这个excel文件

微信认证勋章

讲师达人

悬赏达人

SpreadJS 认证

SpreadJS 高级认证

元老葡萄