使用jxl操作excel时异常:
jxl.read.biff.biffexception: the input file was not found
at jxl.read.biff.file.<init>(file.java:117)
at jxl.workbook.getworkbook(workbook.java:210)
at jxl.workbook.getworkbook(workbook.java:187)
at ldaptool.dataexport.main(dataexport.java:296)
代码:
Workbook wbb = Workbook.getWorkbook(new File(filePath + filename));
WritableWorkbook wb1 = Workbook.createWorkbook(new File(filePath + filename), wbb);
字面意思是文件不存在,查看目录下文件是实实在在存在的,
将代码改用流获取
FileInputStream in = new FileInputStream(new File(filePath + filename));
Workbook wbb = Workbook.getWorkbook(in);
WritableWorkbook wb1 = Workbook.createWorkbook(new File(filePath+ filename), wbb);
OK了!!
jxl.read.biff.biffexception: the input file was not found
at jxl.read.biff.file.<init>(file.java:117)
at jxl.workbook.getworkbook(workbook.java:210)
at jxl.workbook.getworkbook(workbook.java:187)
at ldaptool.dataexport.main(dataexport.java:296)
代码:
Workbook wbb = Workbook.getWorkbook(new File(filePath + filename));
WritableWorkbook wb1 = Workbook.createWorkbook(new File(filePath + filename), wbb);
字面意思是文件不存在,查看目录下文件是实实在在存在的,
将代码改用流获取
FileInputStream in = new FileInputStream(new File(filePath + filename));
Workbook wbb = Workbook.getWorkbook(in);
WritableWorkbook wb1 = Workbook.createWorkbook(new File(filePath+ filename), wbb);
OK了!!