类型不匹配：无法从XSSFSheet转换为HSSFSheet

Question

    File file = new File("/C:/behzad-data/trp.small.xlsx");
    String dataPath=file.getAbsolutePath();
    System.out.println(dataPath);
    POIFSFileSystem fs = new POIFSFileSystem(new FileInputStream(file));

    //XSSFWorkbook wb = new XSSFWorkbook(file);

    HSSFWorkbook wb = new HSSFWorkbook(fs);
    HSSFSheet sheet = wb.getSheetAt(0);
    HSSFRow row;
    HSSFCell cell;

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)
    at org.apache.poi.poifs.storage.HeaderBlock.<init>(HeaderBlock.java:152)

XSSFWorkbook wb = new XSSFWorkbook(file);
 //   HSSFWorkbook wb = new HSSFWorkbook(fs);

但它抱怨说：

Type mismatch: cannot convert from XSSFSheet to HSSFSheet

如何同时解决这两个错误？

Answer 1

为什么不使用workbookfactory，而对两种类型的工作簿只需要处理一个API呢？所以有了这个新的API，您就不必用文件类型来prefexsheet、row等等，只需要这样使用这些类。

File file = new File("C:\\behzad-data\\trp.small.xlsx");
Workbook wb = WorkbookFactory.create(file);

Sheet sheet = wb.getSheetAt(0);
Iterator<Row> rows = sheet.rowIterator();
while (rows.hasNext()) {
    Row row = rows.next();
    // so on and so forth
}

则只需按常规使用wb即可

查看API文档以获取更多信息

<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi</artifactId>
    <version>3.16-beta2</version>
</dependency>
<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi-ooxml</artifactId>
    <version>3.16-beta2</version>
</dependency>
<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi-ooxml-schemas</artifactId>
    <version>3.16-beta2</version>
</dependency>