I'm using Infragistics.Excel.v8.2 (8.2.20082.1000). I am attempting to open an excel file using the " Workbook.Load" method. However, as soon as I open the file, I receive an exception
"An item with the same key has already been added"
I'm not sure why this error is occurring or why it is happening. Any help would be greatly appreciated. I have attached a zip file that contains the spreadsheet.
I thought I would put the stack trace here too (I removed the last line).
at System.ThrowHelper.ThrowArgumentException(ExceptionResource resource)
at System.Collections.Generic.Dictionary`2.Insert(TKey key, TValue value, Boolean add)
at System.Collections.Generic.Dictionary`2.Add(TKey key, TValue value)
at Infragistics.Excel.WorkbookFormatCollection.AddFormat(Int32 index, String format)
at Infragistics.Excel.Serialization.BiffRecords.FORMATRecord.Load(WorkbookSerializationManager manager)
at Infragistics.Excel.Workbook.LoadHelper(Stream stream, String parameterName)
at Infragistics.Excel.Workbook.Load(String fileName)
I tested this out with your xls file with oldest supported version, which is v9.2, and it worked fine for me. So my guess is that this is a bug that has long-since been fixed.
I recommend that you get the latest service release and see if that helps.
How to get the latest service release - Infragistics Community
Thank you for responding. I will attempt to download and install the latest service release and see if that resolves the problem. I'll post another thread here when if the issue is resolved.