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

?

1 2 3 4 5 6 7 8 9 10 11 12

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