blocks|key|197403|text|据我所知，您可以使用此代码读取.xls格式的excel文件|type|unstyled|depth|inlineStyleRanges|entityRanges|data|197404|FileInputStream+in=new+FileInputStream(new+File("filename.xls"));
Wookbook+wb=new+HSSFWorkbook(in);|code-block|syntax|javascript|197405|要阅读新的excel版本(2007及更高版本)：|197406|+FileInputStream+in=new+FileInputStream(new+File("filename.xls"));
++++Wookbook+wb=new+XSSFWorkbook(in);|197407|您将需要的外部jar文件：|197408|+1.+poi-3.9+
+2.+dom4j-1.6.1
+3.+XMLbeams-2.5.0|197409|如果您工作只需要使用.xls，那么只需使用poi-3.0即可。您需要其他jars才能与新版本的excel一起工作。|197410|entityMap^0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|U|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|W|8|@]|9|@]|A|$]]|$1|M|3|N|5|D|7|X|8|@]|9|@]|A|$E|F]]|$1|O|3|P|5|6|7|Y|8|@]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|R|$]]

as per my knowledge you can use this code to read excel files of the .xls format

<pre><code>FileInputStream in=new FileInputStream(new File("filename.xls"));
Wookbook wb=new HSSFWorkbook(in);
</code></pre>

to read the new excel versions(2007 and up): 

<pre><code> FileInputStream in=new FileInputStream(new File("filename.xls"));
 Wookbook wb=new XSSFWorkbook(in);
</code></pre>

external jar files that you will need: 

<pre><code> 1. poi-3.9 
 2. dom4j-1.6.1
 3. XMLbeams-2.5.0
</code></pre>

if you're work only requires you to work with .xls then only poi-3.0 will suffice. You need the other jars to work witht the new versions of excel.

blocks|key|2820897|text|对于旧的Excel格式文件，您可以选择以下方法：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2820898|2820899|HSSF，Excel+'97(-2007)文件格式的POI实现。|ordered-list-item|offset|length|style|CODE|2820900|+|2820901|如果您只想提取文本内容，则可以使用OldExcelExtractor，它将只从文件中提取文本和数字。|unordered-list-item|2820902|
|2820903|如果您需要来自特定单元格的值，则需要采取类似于OldExcelExtractor的方法，在记录级处理文件，并检查OldStringRecord、NumberRecord、<代码>C12和朋友上的坐标。|2820904|2820905|2820906|2820907|​|2820908|2820909|就像你已经提到的，JXL也可以处理一些情况，|2820910|使用JDBC/ODBC驱动。它不像HSSF那样灵活，但对于某些旧格式，它是提取information.|2820911|的唯一方法|2820912|entityMap|0|LINK|mutability|MUTABLE|url|https://poi.apache.org/spreadsheet/|1|https://poi.apache.org/apidocs/org/apache/poi/hssf/extractor/OldExcelExtractor.html|2|https://poi.apache.org/apidocs/org/apache/poi/hssf/record/OldStringRecord.html|3|https://poi.apache.org/apidocs/org/apache/poi/hssf/record/NumberRecord.html|4|http://jexcelapi.sourceforge.net/|5|http://www.java2s.com/Tutorial/Java/0340__Database/UseJDBCODBCbridgetoreadfromExcel.htm^0|0|0|Q|3|0|4|0|0|0|H|H|1|0|0|N|H|1K|F|2|20|C|3|0|0|0|0|0|0|9|3|4|0|H|4|2|9|5|0|0^^$0|@$1|2|3|4|5|6|7|1M|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|1N|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|1O|8|@$F|1P|G|1Q|H|I]]|9|@$F|1R|G|1S|1|1T]]|A|$]]|$1|J|3|K|5|6|7|1U|8|@]|9|@]|A|$]]|$1|L|3|M|5|N|7|1V|8|@]|9|@$F|1W|G|1X|1|1Y]]|A|$]]|$1|O|3|P|5|6|7|1Z|8|@]|9|@]|A|$]]|$1|Q|3|R|5|N|7|20|8|@$F|21|G|22|H|I]]|9|@$F|23|G|24|1|25]|$F|26|G|27|1|28]]|A|$]]|$1|S|3|P|5|6|7|29|8|@]|9|@]|A|$]]|$1|T|3|-4|5|N|7|2A|8|@]|9|@]|A|$]]|$1|U|3|-4|5|6|7|2B|8|@]|9|@]|A|$]]|$1|V|3|W|5|6|7|2C|8|@]|9|@]|A|$]]|$1|X|3|-4|5|6|7|2D|8|@]|9|@]|A|$]]|$1|Y|3|Z|5|E|7|2E|8|@]|9|@$F|2F|G|2G|1|2H]]|A|$]]|$1|10|3|11|5|E|7|2I|8|@$F|2J|G|2K|H|I]]|9|@$F|2L|G|2M|1|2N]]|A|$]]|$1|12|3|13|5|6|7|2O|8|@]|9|@]|A|$]]|$1|14|3|-4|5|6|7|2P|8|@]|9|@]|A|$]]]|15|$16|$5|17|18|19|A|$1A|1B]]|1C|$5|17|18|19|A|$1A|1D]]|1E|$5|17|18|19|A|$1A|1F]]|1G|$5|17|18|19|A|$1A|1H]]|1I|$5|17|18|19|A|$1A|1J]]|1K|$5|17|18|19|A|$1A|1L]]]]

For old Excel format files, you have the following alternatives:

<ol>
<li><a href="https://poi.apache.org/spreadsheet/" rel="noreferrer">HSSF</a>, the <code>POI</code> implementation of the Excel '97(-2007) file format. 

<ul>
<li>If you just want to extract the textual content, then you can use <a href="https://poi.apache.org/apidocs/org/apache/poi/hssf/extractor/OldExcelExtractor.html" rel="noreferrer">OldExcelExtractor</a> which will pull only the 
text and numbers from the file. </li>
<li>If you need the values from a specific cells, then you'll need to take an 
approach a bit like <code>OldExcelExtractor</code>, process the file at the record 
level, and check for the co-ordinates on <a href="https://poi.apache.org/apidocs/org/apache/poi/hssf/record/OldStringRecord.html" rel="noreferrer">OldStringRecord</a>, <a href="https://poi.apache.org/apidocs/org/apache/poi/hssf/record/NumberRecord.html" rel="noreferrer">NumberRecord</a>, <a href="https://poi.apache.org/apidocs/org/apache/poi/hssf/record/OldFormulaRecord.html" rel="noreferrer">OldFormulaRecord</a> and friends. </li>
</ul></li>
<li>Like you already mentioned, <a href="http://jexcelapi.sourceforge.net/" rel="noreferrer">JXL</a> can handle some cases too.</li>
<li>Use a <a href="http://www.java2s.com/Tutorial/Java/0340__Database/UseJDBCODBCbridgetoreadfromExcel.htm" rel="noreferrer">JDBC/ODBC</a> driver. It is not as flexible as <code>HSSF</code> but for some old formats it is the only way to extract the information.</li>
</ol>

I switched from jxl to poi since POI has more features. However, I wasn't able to process the xls files that were generated in the old format. Now I am getting this error:

<blockquote>
 org.apache.poi.hssf.OldExcelFormatException: 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)
</blockquote>

Now I am thinking to use both JXL as wells as POI depending on the xls version so for old format xls files I will use jxl while for newer versions I will use POI. Is this a good solution? Are there any alternatives?

How to process old excel .xls files using POI?

我从jxl切换到poi，因为POI有更多的功能。但是，我无法处理以旧格式生成的xls文件。现在我得到了这个错误： org.apache.poi.hssf.OldExcelFormatException:提供的电子表格似乎是Excel5.0/7.0 (BIFF5)格式。POI仅支持BIFF8格式(从Excel97/200...

问如何使用POI处理旧的excel .xls文件？
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何使用POI处理旧的excel .xls文件？EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何使用POI处理旧的excel .xls文件？
EN