天天看点

java读入delphi生成的excel报错

最近遇到一个问题用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版本太低了。

总之终于是解决了此问题。

继续阅读