java poi 读取有密码加密的Excel文件

String excelPath = "Excel文件路徑";
String password = "Excel文件密碼";
  
Workbook workbook;
InputStream inp = new FileInputStream(excelPath);
//解密
POIFSFileSystem pfs = new POIFSFileSystem(inp);
inp.close();
EncryptionInfo encInfo = new EncryptionInfo(pfs);
Decryptor decryptor = Decryptor.getInstance(encInfo);
decryptor.verifyPassword(password);
workbook = new XSSFWorkbook(decryptor.getDataStream(pfs));

  

posted @ 2019-11-26 15:09  heart..  阅读(1489)  评论(0编辑  收藏  举报