java 读取带密码的excel文件
Java读取带密码的excel文件:报如下错:
Exception in thread "main" jxl.read.biff.PasswordException: The workbook is password protected
at jxl.read.biff.WorkbookParser.parse(WorkbookParser.java:580)
at jxl.Workbook.getWorkbook(Workbook.java:271)
at jxl.Workbook.getWorkbook(Workbook.java:253)
请问各位大侠,知道怎么回事吗?
这是我写的代码:
InputStream iso = new FileInputStream("D:\\assetPasswordTemplate.xls");
Workbook book = Workbook.getWorkbook(iso);
Sheet sheet = book.getSheet(0);
SheetSettings ss = sheet.getSettings();
String pass = ss.getPassword();
System.out.println("pass: "+pass);
book.close();
请各位大侠帮帮忙,先行谢过了!有其他的方法也行。