jxl.read.biff.biffexception: the input file was not found

最新推荐文章于 2020-07-09 14:22:06 发布

原创最新推荐文章于 2020-07-09 14:22:06 发布 · 1.3k 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#Java #Excel

本文介绍使用jxl操作Excel遇到的“文件未找到”异常，并给出了解决方案，通过使用FileInputStream替换直接文件路径读取的方式，成功解决了问题。

使用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了！！