I have a C# application that is trying to load an Excel workbook using the Infragistic's Excel Workbook Load method. I am having an issue with one particular Excel workbook. The error I am seeing is:
"An item with the same key has already been added."
As mentioned, I am having issues with one particular Excel workbook. All the other workbooks I've processed to date load correctly. The load method used is straight forward:
Workbook workbook = Workbook.Load(excelFileLocation, false)
I try and load this one workbook and an error is thrown.
The version of Infragistics software being used is Infragistics3.Excel.v10.1.
I can't figure out what is causing the error. Is there some type of diagnostic tool available that will allow me to break down where this error may be coming from?
Hello Valliappan,
Did you try this with the trial version of 12.1 which the original author of this thread stated to be helpful?
Hi Boris,
Am getting same issue ( "An item with the same key has already been added.") on loading particular excel workbook but it works for others. what could be the reason? am using Infragistics 11.2 ( minor version - 2050) .. do we have a patch?
Thanks,
Valliappan
I went and loaded Net Advantage 12.1 as a trial version. I executed my application and was able to load the Excel workbook that was throwing an error on load. And there was great rejoicing.
Thanks for your help.
Hello Mike,
This seems to be an issue which has already been fixed. So what you could do is to download the latest service release available for your current version or either download the trial version of Net Advantage 12.1 and test your application against it.