& g9 I+ f, b6 K上边代码,读取Excel2003(xls)的文件没问题,但是一旦读取的是Excel2007(xlsx)的文件,就会报异常:“The supplied data appears to be in the Office 2007+ XML. You are calling the part of POI that deals with OLE2 Office Documents. You need to call a different part of POI to process this data (eg XSSF instead of HSSF)”' {3 B# y( M& a- x
查阅了资料,Excel2007版本的Excel文件需要使用XSSFWorkbook来读取,如下:, k& V& V1 d# X" d, [
public void test(File file) throws IOException { 5 @9 t' T& g& V6 u ?& y! ]9 ` InputStream inp = new FileInputStream(file);1 b% F$ x8 l3 D! m
XSSFWorkbook workbook = new XSSFWorkbook(inp); l& Y& Y! c. F# `! v. N2 b
+ A7 M* y4 S) ?3 ?( _' l" c // workbook...遍历操作5 M E1 r& T3 }3 |7 o' k" n
}2 s$ k9 r+ X ~
注意:XSSFWorkbook需要额外导入poi-ooxml-3.9-sources.jar和poi-ooxml-schemas-3.9.jar。 ! x2 S% F& K% H3 h/ |/ @这样,Excel2007的导入没问题了,但是导入Excel2003又报异常。% s8 y8 v( O4 H" {
所以,在导入Excel的时候,尽量能判断导入Excel的版本,调用不同的方法。 / D" O( j% D9 v我想到过使用文件后缀名来判断类型,但是如果有人将xlsx的后缀改为xls时,如果使用xlsx的函数来读取,结果是报错;虽然后缀名对了,但是文件内容编码等都不对。- m5 j0 k' O3 J- @( f6 Z8 `+ Z
最后,推荐使用poi-ooxml中的WorkbookFactory.create(inputStream)来创建Workbook,因为HSSFWorkbook和XSSFWorkbook都实现了Workbook接口。代码如下: : h) y3 f; F- i# E6 {; _Workbook wb = WorkbookFactory.create(is);1 W# A7 C% s5 N7 S
4 Z5 R) k6 J; @# S y6 x; @可想而知,在WorkbookFactory.create()函数中,肯定有做过对文件类型的判断,一起来看一下源码是如何判断的:0 a8 r* Q! n3 m; d8 m& h
/**2 _, x r" ]+ q7 m4 F
* Creates the appropriate HSSFWorkbook / XSSFWorkbook from + W6 p |% j+ | i8 @ * the given InputStream.% m V1 U4 O# Z7 n2 p
* Your input stream MUST either support mark/reset, or" t1 X: j9 j% Z/ u( M
* be wrapped as a {@link PushbackInputStream}!3 k: l7 S3 _ [ Z7 h1 `8 w4 l. o
*/' u0 F% s& s. F B- H1 `0 E
public static Workbook create(InputStream inp) throws IOException, InvalidFormatException { . j% a4 I9 E/ O" X; I+ Q // If clearly doesn't do mark/reset, wrap up) ` l9 s3 z- ]# f* B# a
if(! inp.markSupported()) {5 M! Y( _5 y! ^
inp = new PushbackInputStream(inp, 8); Y4 c, ^ Z& G- V }. O% B, M0 _# P: b& K
5 k, P! b* _/ l# p1 l
if(POIFSFileSystem.hasPOIFSHeader(inp)) { 6 l, i- h7 W- D/ x1 y" J return new HSSFWorkbook(inp); % [" [% Y0 L+ F, ~. ]. a) g } 2 I1 m0 x2 c7 X& g3 v if(POIXMLDocument.hasOOXMLHeader(inp)) { ! t5 g# f7 D z. X; q return new XSSFWorkbook(OPCPackage.open(inp));/ N3 d& U% J$ [
}; y5 W" Y1 f$ B. }
throw new IllegalArgumentException("Your InputStream was neither an OLE2 stream, nor an OOXML stream"); $ I: m# [3 `* W } 4 _# M) S8 U8 a3 j" z# c , a" ]' w( a4 M* W# n可以看到,有根据文件类型来分别创建合适的Workbook对象。是根据文件的头部信息去比对进行判断的,此时,就算改了后缀名,还是一样通不过。 1 B0 j& N& j" z, L6 o7 I- o7 C `% A9 x% v( q/ M. A e: t