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!
Roberto
Excel_Test_1286.zip
