java 读取excel2007 问题 报错 ！！

[xulehome]

我的用的XSSFWorkbook来读取excel2007里的内容

List<List<String>> result = new ArrayList<List<String>>();

Sheet sheet = wb.getSheetAt(0);
int rowNum = sheet.getLastRowNum();

for (int j = 0; j <= rowNum; j++) {
Row row = sheet.getRow(j);
int cellNum = row.getLastCellNum();

List<String> rowList = new ArrayList<String>();
for (int k = 0; k < cellNum; k++) {
rowList.add(row.getCell(k) == null ? null : row.getCell(k)
.toString());
}

result.add(rowList);
}
return result;

File f = new File(fileName);
FileInputStream is = new FileInputStream(f);
[color=#FF0000]wb = new XSSFWorkbook(is); 这句就报错
org.apache.poi.openxml4j.exceptions.InvalidOperationException: Can't open the specified file: 'D:\apache-tomcat-6.0.18\apache-tomcat-6.0.18\temp\poifiles\poi-ooxml--493107868.tmp'
at org.apache.poi.openxml4j.opc.ZipPackage.<init>(ZipPackage.java:102)
at org.apache.poi.openxml4j.opc.OPCPackage.open(OPCPackage.java:199)
at org.apache.poi.openxml4j.opc.OPCPackage.open(OPCPackage.java:178)




是不是导入的包有问题啊

[/color]

[liuyuhua0066]

貌似不支持2007的excel。你换2003的试试。

[smmi]

1、XSSFWorkbook是否支持excel2007
2、关闭打开的文件

[wangmengmeng2012]

等待高人回答！我的也是这个错误！
XSSFWorkbook就是针对2007的，HSSFWorkbook是对03的啊！

[軒轅劍]

org.apache.poi.openxml4j.exceptions.InvalidOperationException: Can't open the specified file: 'D:\apache-tomcat-6.0.18\apache-tomcat-6.0.18\temp\poifiles\poi-ooxml--493107868.tmp'


你的文件出问题了，你的文件名：poi-ooxml--493107868.tmp