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