我的用的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]
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]
解决方案 »
- jstl的forEach嵌套问题,三层
- webservice怎么获取自定义异常?
- <JSP:plugin>出错,请指教
- 关于finalize()方法自动调用的测试.
- jsp中如何连接sql server express 2005
- JSTL的问题阿.~帮下忙吧~
- 小弟我在 Mysql下连接池做了一个ConnectionDB类,运行没错,可是通过JSP页面调用时就出现了 ClassCastException异常,请教怎么解决??
- spring 监听器开始失败。。。
- 如何使<html:link 映射成的相对地址,变成绝对地址
- 帮忙一下
- SmartUpload上传文件名为中文时报错
- js函数定义方式为什么可以这样写
2、关闭打开的文件
XSSFWorkbook就是针对2007的,HSSFWorkbook是对03的啊!
你的文件出问题了,你的文件名:poi-ooxml--493107868.tmp