爱玺玺

File f = new File("E:\\202207月.xlsx");

InputStream inputStream = new FileInputStream(f);

XSSFWorkbook workbook = null;

POIFSFileSystem poifsFileSystem = new POIFSFileSystem(inputStream);

inputStream.close();

EncryptionInfo encryptionInfo = new EncryptionInfo(poifsFileSystem);

Decryptor decryptor = Decryptor.getInstance(encryptionInfo);

boolean verifyPassword = decryptor.verifyPassword("308");

        if (!verifyPassword) {

            throw new Exception("excel 密码错误！");

        }

        workbook = new XSSFWorkbook(decryptor.getDataStream(poifsFileSystem));