Validating Sheet Password

monitorjbl / excel-streaming-reader

An easy-to-use implementation of a streaming Excel reader using Apache POI

Apache License 2.0

946 stars 343 forks source link

Open addijhaq opened 5 years ago

addijhaq commented 5 years ago

Hello,

I've noticed that there is a way to "unlock" a sheet via a password field on the StreamingReader.builder()

but this doesn't allow me to check on a sheet with protection....

I need to verify that the sheet still maintains it's password integrity before I read it.

Is this possible? I've tried casting the Sheet to XSSFSheet from the StreamingSheet and of course this does not work. Thanks!

apixandru commented 5 years ago

Do you have a runnable example that manifests this behavior?