我在从
.xls
文件
错误
org.apache.poi.hssf.record.RecordInputStream$LeftoverDataException:记录输入流$LeftoverDataException
记录0x10(DeltaRecord)的初始化剩余8字节
还有待阅读。在
org.apache.poi.hssf.record.RecordInputStream.hasNextRecord(RecordInputStream.java:178)
在
org.apache.poi.hssf.record.RecordFactoryInputStream.nextRecord(RecordFactoryInputStream.java:235)
在
org.apache.poi.hssf.record.RecordFactory.createRecords(RecordFactory.java:494)
在
org.apache.poi.hssf.usermodel.HSSFWorkbook.(HSSFWorkbook.java:356)
在
org.apache.poi.hssf.usermodel.HSSFWorkbook(HSSFWorkbook.java:319)
在
org.apache.poi.hssf.usermodel.HSSFWorkbook(HSSFWorkbook.java:266)
在
org.apache.poi.hssf.usermodel.HSSFWorkbook.(HSSFWorkbook.java:236)
代码
我用过。
InputStream input = new FileInputStream(fileName);
Workbook wb = WorkbookFactory.create(input);
Sheet sheet = wb.getSheetAt(0);
int lastCol = sheet.getLastRowNum();
System.out.println(lastCol);
Maven依赖项
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi-ooxml</artifactId>
<version>3.17</version>
</dependency>