ExcelRW: Failure reading styles while opening file

[Roberto Obispo]

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_5160.zip

[Administrator]

Hi Roberto, 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. Best regards, Stephen. >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_5160.zip > >

[Roberto Obispo]

Oh, ok, thanks. Please, let me know when it''s fixed as soon as possible!

Best regards

Roberto Obispo