Issue with dealing sheet that are protected although we could read but not able to iterate the rows

monitorjbl / excel-streaming-reader

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

Apache License 2.0

953 stars 344 forks source link

Issue with dealing sheet that are protected although we could read but not able to iterate the rows #144

Open hariharansethu opened 6 years ago

hariharansethu commented 6 years ago

@monitorjbl I could able to open the excel in compatibility mode but through code I am facing the issue as such the cellTypeEnum returns numeric and throws error.

Thought to do a workaround by check if a sheet is protected or not but it looks like there is no option to check .

Any help on this would be appreciated.Thanks !!