请教一个POI的问题！读取EXCEL报错！ 急！ 请各位大侠帮帮我！

[zhaojuzi]

FileInputStream stream = new FileInputStream(filePath);
POIFSFileSystem wbFs = new POIFSFileSystem(stream);
HSSFWorkbook wb = new HSSFWorkbook(wbFs);执行到这里，抛出下面异常.




Exception in thread "main" org.apache.poi.hssf.record.RecordFormatException: Unable to construct record instance
at org.apache.poi.hssf.record.RecordFactory.createRecord(RecordFactory.java:191)
at org.apache.poi.hssf.record.RecordFactory.createRecords(RecordFactory.java:115)
at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:205)
at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:153)
at com.nec.jp.cts.service.ReadSearch.main(ReadSearch.java:22)
Caused by: java.lang.reflect.InvocationTargetException
at sun.reflect.GeneratedConstructorAccessor5.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at org.apache.poi.hssf.record.RecordFactory.createRecord(RecordFactory.java:179)
... 4 more
Caused by: java.lang.UnsupportedOperationException: Unknown Ptg in Formula: 0xffffffc4 (-60)
at org.apache.poi.hssf.record.formula.Ptg.createPtg(Ptg.java:357)
at org.apache.poi.hssf.record.formula.Ptg.createParsedExpressionTokens(Ptg.java:98)
at org.apache.poi.hssf.record.NameRecord.fillFields(NameRecord.java:740)
at org.apache.poi.hssf.record.Record.<init>(Record.java:56)
at org.apache.poi.hssf.record.NameRecord.<init>(NameRecord.java:143)
... 8 more

[大海之粟]

HSSFWorkbook(wbFs);没有这个参数的构造函数,所以抛出异常 Unable to construct record instance

[yiyi_wx]

可能是lz excel中的数据或格式有问题 先建一个excel 里面简单的填充几个单元格
看看还报这个错不了 如果没问题了 说明问题出在excel了

[zhaojuzi]

谢谢楼上的
新建Excel的方法我试过了
不会报错
但是有要求不可以新建的
必须读原始的那个文件
- -！
不过仍然谢谢你 ^-^

[zhaojuzi]

谢谢楼上的两位大侠
小妹我结贴了
小妹第一次发帖
也没多少积分
还请两位不要嫌弃^-^

[zhao_tk]

解决方法也不说下。。bs