异常： “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)”

Excel2003版的.xls文件读取  HSSFWorkbook workbook = new HSSFWorkbook(fs);
Excel2007版本的Excel文件读取  XSSFWorkbook workbook = new XSSFWorkbook(fs);

所以，在导入Excel的时候，尽量能判断导入Excel的版本，调用不同的方法。

我想到过使用文件后缀名来判断类型，但是如果有人将xlsx的后缀改为xls时，如果使用xlsx的函数来读取，结果是报错；虽然后缀名对了，但是文件内容编码等都不对。

最后，推荐使用package org.apache.poi.ss.usermodel包中WorkbookFactory.create(inputStream)来创建Workbook，因为HSSFWorkbook和XSSFWorkbook都实现了Workbook接口。代码如下：

Workbook wb = WorkbookFactory.create(is);

可想而知，在WorkbookFactory.create()函数中，肯定有做过对文件类型的判断，一起来看一下源码是如何判断的：

* Creates the appropriate HSSFWorkbook / XSSFWorkbook from * the given InputStream. * Your input stream MUST either support mark/reset, or * be wrapped as a {@link PushbackInputStream}! public static Workbook create(InputStream inp) throws IOException, InvalidFormatException { // If clearly doesn't do mark/reset, wrap up if(! inp.markSupported()) { inp = new PushbackInputStream(inp, 8); if(POIFSFileSystem.hasPOIFSHeader(inp)) { return new HSSFWorkbook(inp); if(POIXMLDocument.hasOOXMLHeader(inp)) { return new XSSFWorkbook(OPCPackage.open(inp)); throw new IllegalArgumentException("Your InputStream was neither an OLE2 stream, nor an OOXML stream");

可以看到，有根据文件类型来分别创建合适的Workbook对象。是根据文件的头部信息去比对进行判断的，此时，就算改了后缀名，还是一样通不过。

异常：“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)”Excel2003版的.xls文件读取HSSFWorkbook .. please read the following items before using: 1.本站仅对原软件包“依样”打包，未做过任何改动，但不保证所提供软件或程序的完整性和安全性。 1.Our website only pack up the original software without any altering, but we cannot guarantee the integrality and safety of the software or program. 2. 请在使用前查毒 (这也是您使用其它网络资源所必须注意的) 。 2.please check the virus before using-that s what you must pay attention to while usingother net resources. 3. 由本站提供的程序对您的网站或计算机造成严重后果的本站概不负责。 3.we are not responsible for the severe result of your website or computer caused by the program supplied by our website.　 4. 转载本站提供的资源请勿删除本说明文件。 4.when you transfer the resources of our website, please do not delete this instruction. 使用springMVC和 POI 处理 excel 文件，使用springMVC的MultipartFile接受文件流，在使用creat的时候报错。 InputStream inputStream = file.getInputStream(); Workbook workbook = WorkbookFactory.create(inputStream); 错误信息： java.lang.IllegalArgumentException: Your InputStream was neither an function [seg] = character_segmentation(bw) ％ character_segmentation: Returns the digit segments in the supplied binary image. ％ The function uses the "segment" function, keeping only the seven ％ segments in the result with largest area, and in case less than seven ％ segments were found, it attempts to recall the function, making the ％ separation between the already found segments cl ear er (by cleaning the ％ bits which are there.