apache poi 从 2.5 升级到 3.8 出现 Excel 错误 [英] apache poi upgrade from 2.5 to 3.8 gives Excel error

查看:44
本文介绍了apache poi 从 2.5 升级到 3.8 出现 Excel 错误的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我们需要提供对 Excel 2010 的支持,所以已经升级到 Apache poi 3.8.但是在下载 excel 时,打开需要很长时间,并且还提供错误消息EXCEL 发现无法读取的内容.是否要恢复此工作簿的内容?如果您信任此工作簿的来源,请单击是"

We need to provide support for Excel 2010 so have upgraded to Apache poi 3.8. But while downloading the excel it takes so much time for opening and also provides error message as "EXCEL found unreadable content. Do you want to recover the contents of this workbook? If you trust the source of this workbook, click yes"

点击是"后,它又给了我一个弹出窗口,上面写着,

And after clicking "yes", it gives me one more pop up which says,

Excel 已完成文件级验证和修复.此工作簿的某些部分可能已被修复或丢弃.删除的记录:从/xl/worksheets/sheet1.xml 部分合并单元格

Excel completed file level validation and repair. Some parts of this workbook may have been repaired or discarded. Removed Records: Merge cells from /xl/worksheets/sheet1.xml part

请帮助我解决这个问题.

Kindly help me resolving this issue.

谢谢

推荐答案

我在使用 POI 3.9 时遇到了类似的问题

I had a similar problem using POI 3.9

是下面的

  1. 我在 LibreOffice 4.0.2.2
  2. 中创建了 XLSX 电子表格
  3. 我可以在 Office 2010 中打开这个 LibreOffice 生成的 XLSX问题
  4. 通过 POI,我打开了这本​​工作簿并写信给它.很简单的东西,仅字符串
  5. Office 2010 然后报告我的 XLSX 损坏并修复"它
  1. I created the XLSX spreadsheet in LibreOffice 4.0.2.2
  2. I could open this LibreOffice generated XLSX in Office 2010 with no problems
  3. With POI I opened this workbook and wrote to it. Very simple stuff, Strings only
  4. Office 2010 then reports that my XLSX is corrupt and 'fixes' it

我在 Word 2010 中创建了一个新的 XLSX 并使用 POI 3.9 对其进行了修改,问题就消失了

I created a new XLSX in Word 2010 and modified it with POI 3.9 and the problem went away

这篇关于apache poi 从 2.5 升级到 3.8 出现 Excel 错误的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆