Question

java中解析xlsx文件时无论是使用XSSFWorkbook还是HSSFWorkbook都报错 officeXmlFileException

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)
求各位大神帮忙解答

Answer 1

文档保存为2003的xls格式。

Answer 2

版本够新的话，应该都会有的

HSSFWorkbook:是操作Excel2003以前（包括2003）的版本，扩展名是.xls

XSSFWorkbook:是操作Excel2007的版本，扩展名是.xlsx

Answer 3

新版本的POI可以