Java导入excel文件报 The supplied data appears to be in the Office 2007+ XML. You are calling the part of

 

报错信息: org.apache.poi.poifs.filesystem.OfficeXmlFileException: 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) 

原因: HSSFWorkbook只能处理扩展名为.xls的文件，也就是excel2003

     XSSFWorkbook只能处理扩展名为.xlsx的文件，也就是excel2007

解决办法：可以将.xlsx文件另存为.xls文件再进行处理（不是直接改扩展名）。

下面是我直接修改扩展名的错误示例: