This has been identified as a bug. I have filed a bug report with the development team and will try to get it fixed before the next release [July 11th]. Sorry for the inconvenience.
>Hi! I''ve had an error while opening a sheet (see enclosed excel file), and the exception says it''s a style problem.
>This is stack dump I had when I had the error:
>System.ArgumentException: Collection already contains style with same names NotDeclared_5.
> at Syncfusion.ExcelRW.Implementation.Collections.StylesCollection.Add(IStyle style)
> at Syncfusion.ExcelRW.Implementation.WorkbookImpl.CreateStyle(ExtendedFormatImpl format, StyleRecord style, Hashtable hashStyles, Hashtable hashOldParent)
> at Syncfusion.ExcelRW.Implementation.WorkbookImpl.FindOrCreateStyle(ExtendedFormatImpl format, ArrayList arrStyles, Hashtable hashStyles, Hashtable hashOldParent)
> at Syncfusion.ExcelRW.Implementation.WorkbookImpl.CreateAllStyles(ArrayList arrStyles, Hashtable hashStyles, Hashtable hashOldParent)
> at Syncfusion.ExcelRW.Implementation.WorkbookImpl.Parse(BiffReader reader, Boolean ignoreStyle)
> at Syncfusion.ExcelRW.Implementation.WorkbookImpl..ctor(IApplication application, Object parent, String FileName, Boolean ignoreStyles)
> at Syncfusion.ExcelRW.Implementation.WorkbookImpl..ctor(IApplication application, Object parent, String FileName)
> at Syncfusion.ExcelRW.Implementation.ApplicationImpl.CreateWorkbook(Object parent, String strTemplateFile)
> at Syncfusion.ExcelRW.Implementation.Collections.WorkbooksCollection.Open(String Filename)
> at ExcelReader.ExcelReader.Open(String ExcelPath) in C:\Proyectos\CodigoJSC\ExcelReader\ExcelReader\ExcelReader.vb:line 43
>Please, do you know how to avoid this? Is there a way to read this excel without having this problem? May be a way to turn off the styles for a certain excelfile, or something like that...
>Thank you very much!