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:
通过提供的S preadsheet似乎是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:
<一个href=\"http://www.microsoft.com/en-us/download/details.aspx?id=3\">http://www.microsoft.com/en-us/download/details.aspx?id=3
运行转换文件 excelcnv.exe -oice&LT;输入文件&gt; &LT;输出文件&gt;
。您可以尝试直接从您的code作为外部程序运行它,或者创建一些批处理文件。有一个从 mrdivo 是在社会MSDN <一个很好的解释href=\"http://social.msdn.microsoft.com/Forums/office/en-US/8becabda-0014-4e06-8354-5f576bf46595/convert-bulk-using-ofcexe\">here.
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.
这篇关于Excel中BIFF5到BIFF8转换的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!