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));

  

原文地址:https://www.cnblogs.com/junrong624/p/11935655.html