最近遇到一个问题用delphi生成一个excel文件,用java读取excel内容,通过java的POI读入时报错如下:
java.lang.RuntimeExceptception: Unexpected record type (e (org.apache.poi.hssf.record.DimensionsRecsRecord)
at at org.apache.poi.hssf.record.aggregates.RowRecordsAggsAggregate.(t>(RowRecordsAggregate.java:97)
a)
at at org.apache.poi.hssf.model.InternalSheetheet.(t>(InternalSheet.java:172)
a)
at at org.apache.poi.hssf.model.InternalSheet.createSheet(Iet(et(InternalSheet.java:127)
a)
at at org.apache.poi.hssf.usermodel.HSSFWorkbook.ook.(t>(HSSFWorkbook.java:291)
a)
at at org.apache.poi.hssf.usermodel.HSSFWorkbook.ook.(t>(HSSFWorkbook.java:243)
a)
at at org.apache.poi.hssf.usermodel.HSSFWorkbook.ook.(t>(HSSFWorkbook.java:187)
a)
at at org.apache.poi.hssf.usermodel.HSSFWorkbook.ook.(t>(HSSFWorkbook.java:322)
a)
at at org.apache.poi.hssf.usermodel.HSSFWorkbook.ook.(t>(HSSFWorkbook.java:303)
a)
at at com.chinagas.common.utils.ExcelUtils.xls_rea_reader_settle(le(ExcelUtils.java:325)
a)
at at com.chinagas.common.utils.ExcelUtils.main(Exc(in(ExcelUtils.java:377)
几经周折,试了各种方式都不行,认为应该是不同语言不谦容,准备换语言解决。
最后找到问题解决办法:
用XLSReadWriteII4替换XLSReadWriteII2解决了,估计应该是XLSReadWriteII2版本太低了。
总之终于是解决了此问题。