I got the following error while i was trying to load Excel file stream. I am using Infragistics2.Excel.v8.2. I can open the file from MS Excel.
Index was out of range. It must be non-negative and less than the size of the collection.
Parameter name: index Actual value was 1.
at Infragistics.Excel.WorksheetCollection.get_Item(Int32 index) at Infragistics.Excel.Serialization.BiffRecords.EOFRecord.Load(WorkbookSerializationManager manager) at Infragistics.Excel.Serialization.WorkbookSerializationManager.LoadCurrentRecord() at Infragistics.Excel.Serialization.WorkbookSerializationManager.Load() at Infragistics.Excel.Workbook.LoadHelper(Stream stream, String parameterName) at Infragistics.Excel.Workbook.Load(Stream stream)
Dear, same error here with the 2018.2 version.
In a specific excel file, I can open with Excel but I got Index was out of range. Must be non-negative and less than the size of the collection parameter ...
If I open this file with Excel and I save it again I have no issue, but it's a workaround that I don't want to use.
I can send you the file if you want.
I don't believe this issue was reported or fixed. I have forwarded this post to the Developer Support Manager and a DS engineer will be contacting you about this issue.
I am getting this same error now.
Did this ever get resolved?