poi操作excel2007版出错
public static List<List<Object>> read2007Excel(File file) throws FileNotFoundException, IOException
{
List<List<Object>> list =new LinkedList<List<Object>>();
FileInputStream fs = new FileInputStream(file);
XSSFWorkbook xwb = new XSSFWorkbook(fs);
//得到Excel工作表对象
XSSFSheet sheet=xwb.getSheetAt(0);
//获取行对象
XSSFRow row=null;
//获取单元格对象
XSSFCell cell=null;
Object object="";
for(inti=sheet.getFirstRowNum()i<sheet.getPhysicalNumberOfRows();i++)
{
row=sheet.getRow(i);
if(row==null)
{
continue;
}
List<Object> linked = new LinkedList<Object>();
for(int j= 0; j < row.getLastCellNum();j++)
{
cell=row.getCell(j);
if(cell==null)
{
continue;
}
object=cell.toString();
linked.add(object);
System.out.print(object+" ");
}
System.out.println();
list.add(linked);
}
return list;
}
报的下面错误:
Exception in thread "main" org.apache.poi.openxml4j.exceptions.InvalidOperationException: Can't open the specified file: 'C:\DOCUME~1\hu\LOCALS~1\Temp\poifiles\poi-ooxml-259786220.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)
at org.apache.poi.util.PackageHelper.open(PackageHelper.java:53)
at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:176)
at org.scbit.lsbi.gcp.service.poiText.read2007Excel(poiText.java:244)
at org.scbit.lsbi.gcp.service.poiText.textExcel(poiText.java:321)
at org.scbit.lsbi.gcp.service.poiText.main(poiText.java:145)
求大神解决