Protected View - Enable Editing

Nov 3, 2011 at 6:04 PM

Files that are downloaded from the internet may be in "Read Only" mode.  When you open them in excel you get the "Protected View" bar at the top with "Enable Editing" button.

Unless I click that button, I am not able to get Excel Data Reader to open these files.

When attempting to do the first .Read() operation I get this:

System.NullReferenceException: Object reference not set to an instance of an object.
   at Excel.ExcelBinaryReader.findFirstDataCellOffset(Int32 startOffset)
   at Excel.ExcelBinaryReader.initializeSheetRead()
   at Excel.ExcelBinaryReader.Read()

Is there any way around these?

Sep 9, 2013 at 9:40 AM
"Is there any way around these?"
i am in the same trouble!