excel-streaming-reader
excel-streaming-reader copied to clipboard
Issue with dealing sheet that are protected although we could read but not able to iterate the rows
@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 !!