Excel biff5 到 biff8 的转换 [英] Excel biff5 to biff8 conversion
问题描述
我的系统使用 Apache-POI 来管理一些 xls 文件.现在我有将近 300 个 xls 文件,但它们似乎是旧格式,所以我得到了这个例外:
My system uses Apache-POI to manage some xls files. Now I've got almost 300 xls files, but it appears that they are in an old format so i got this exception:
所提供的电子表格似乎是 Excel 5.0/7.0 (BIFF5) 格式.POI 仅支持 BIFF8 格式(来自 Excel 版本 97/2000/XP/2003)
The supplied spreadsheet seems to be Excel 5.0/7.0 (BIFF5) format. POI only supports BIFF8 format (from Excel versions 97/2000/XP/2003)
有没有办法处理这个问题或将所有这些文件自动转换为 biff8 格式?
Is there a way to handle that or to automatically convert all those files to a biff8 format?
推荐答案
将其转换为 OOXLS 格式,POI 支持 BIFF8 和更新的 OOXLS.下载微软官方转换器包:
Go with converting it to OOXLS format, POI supports both BIFF8 and newer OOXLS. Download official Microsoft converter pack:
http://www.microsoft.com/en-us/download/details.aspx?id=3
通过运行excelcnv.exe -oice <输入文件>来转换文件<输出文件>
.您可以尝试直接从您的代码作为外部程序运行它,或者创建一些批处理文件.mrdivo 在社交 msdn 这里.
Convert files by running excelcnv.exe -oice <input file> <output file>
. You can try run it directly from your code as external program, or create some batch file. There is a good explanation from mrdivo at social msdn here.
编辑
从 2018 年 6 月 21 日起不再提供上述从 microsoft.com 下载的内容.但是,excelcnv.exe
是某些 Microsoft Office 安装的标准部分.已确认可与 Office 2014 和 Office 2016 以及可能的其他版本一起部署.它可以在以下位置找到:
The download mentioned above from microsoft.com is no longer available as of 6/21/2018. However, excelcnv.exe
is a standard part of some Microsoft Office installations. It has been confirmed to be deployed with Office 2014 and Office 2016, and possibly other versions. It can be found at:
C:\Program Files (x86)\Microsoft Office\root\Office16` (or `Office14`).
这篇关于Excel biff5 到 biff8 的转换的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!