poi解析execl表格文件(.xls)出现的问题
The supplied data appears to be in the OLE2 Format. You are calling the part of POI that deals with OOXML (Office Open XML) Documents. You need to call a different part of POI to process this data (eg HSSF instead of XSSF)
发现这个文件的格式不是标准的excel文件（.xls或者.xlsx），
引入的依赖
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi-ooxml</artifactId>
<version>4.1.0</version>
</dependency>
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi</artifactId>
<version>4.1.0</version>
</dependency>
调用 ExcelData sheet1 = new ExcelData("d:\\excel\\工单表数据正确文件 - 副本.xlsx", "Sheet1");
ExcelData(String filePath,String sheetName){
FileInputStream fileInputStream = null;
try {
fileInputStream = new FileInputStream(filePath);
XSSFWorkbook sheets = new XSSFWorkbook(fileInputStream);
//获取sheet
sheet = sheets.getSheet(sheetName);
} catch (Exception e) {
e.printStackTrace();
}
}
调用后报上面异常
XSSFWorkbook 读取文件转化成 HXSSFWorkbook 就可以读取文件
上面的依赖解析表格自己定义解析 比较灵活，但是自己写的内容太多
推荐使用 easypoi解析excel
推荐使用 easypoi解析excel
推荐使用 easypoi解析excel
<dependency>
<groupId>cn.afterturn</groupId>
<artifactId>easypoi-spring-boot-starter</artifactId>
<version>4.4.0</version>
</dependency>
