Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
235
An item with the same key has already been added
posted

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.

Thanks

Book1.zip
Parents
No Data
Reply
  • 235
    posted

    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.Serialization.WorkbookSerializationManager.LoadCurrentRecord()

       at Infragistics.Excel.Serialization.WorkbookSerializationManager.Load()

       at Infragistics.Excel.Workbook.LoadHelper(Stream stream, String parameterName)

       at Infragistics.Excel.Workbook.Load(String fileName)

Children