且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

org.apache.poi.POIXMLException:org.apache.poi.openxml4j.exceptions.InvalidFormatException:

更新时间:2021-07-03 17:17:52

您正试图读取 XLS 有明确的实施POI类 XLSX

You are trying to read xls with explicit implementation poi classes for xlsx.

G:\\硒Jar文件\\ TESTDATA \\数据 XLS

G:\Selenium Jar Files\TestData\Data.xls

要么使用HSSFWorkbook$c$c>和HSSFSheet$c$c>类或让您的实现更通用,通过使用共享接口等;

Either use HSSFWorkbook and HSSFSheet classes or make your implementation more generic by using shared interfaces, like;

修改

XSSFWorkbook workbook = new XSSFWorkbook(file);

要:

 org.apache.poi.ss.usermodel.Workbook workbook = WorkbookFactory.create(file);

和变化:

XSSFSheet sheet = workbook.getSheetAt(0);

要:

org.apache.poi.ss.usermodel.Sheet sheet = workbook.getSheetAt(0);