Exception on Workboo.SaveAs

[Administrator]

Can someone please point me in the direction of the cause for the following exception:

MyE.ToString() "System.InvalidCastException: Unable to cast object of type ''Syncfusion.XlsIO.Implementation.NameImpl'' to type ''Syncfusion.XlsIO.ICombinedRange''.\r\n at Syncfusion.XlsIO.Implementation.Charts.ChartSerieImpl.get_PointNumber()\r\n at Syncfusion.XlsIO.Implementation.Charts.ChartLegendEntriesColl.get_Count()\r\n at Syncfusion.XlsIO.Implementation.Charts.ChartSerieImpl.SerializeLegendEntries(OffsetArrayList records)\r\n at Syncfusion.XlsIO.Implementation.Charts.ChartSerieImpl.Serialize(OffsetArrayList records)\r\n at Syncfusion.XlsIO.Implementation.Charts.ChartSeriesCollection.Serialize(OffsetArrayList records)\r\n at Syncfusion.XlsIO.Implementation.Charts.ChartImpl.SerializeChart(OffsetArrayList records)\r\n at Syncfusion.XlsIO.Implementation.Charts.ChartImpl.Serialize(OffsetArrayList records)\r\n at Syncfusion.XlsIO.Implementation.Shapes.ChartShapeImpl.SerializeShape(MsofbtSpgrContainer spgrContainer)\r\n at Syncfusion.XlsIO.Implementation.Shapes.ShapeImpl.Serialize(MsofbtSpgrContainer spgrContainer)\r\n at Syncfusion.XlsIO.Implementation.Collections.ShapeCollectionBase.Serialize(OffsetArrayList records, UInt32 uiStartId)\r\n at Syncfusion.XlsIO.Implementation.WorksheetBaseImpl.SerializeMsoDrawings(OffsetArrayList records)\r\n at Syncfusion.XlsIO.Implementation.WorksheetImpl.SerializeMsoDrawings(OffsetArrayList records)\r\n at Syncfusion.XlsIO.Implementation.WorksheetImpl.Serialize(OffsetArrayList records)\r\n at Syncfusion.XlsIO.Implementation.WorkbookImpl.Serialize(OffsetArrayList records, ExcelSaveType saveType)\r\n at Syncfusion.XlsIO.Implementation.WorkbookImpl.SaveAs(String FileName, ExcelSaveType saveType)\r\n at Syncfusion.XlsIO.Implementation.WorkbookImpl.SaveAs(String FileName)\r\n at ReportBuilder.ExcelReportBuilder.SaveReport() in C:\\Working\\Internal\\Utilities\\Kelley\\ReportBuilder\\ExcelReportBuilder.cs:line 343\r\n at ReportBuilder.ExcelReportBuilder.BuildReport() in C:\\Working\\Internal\\Utilities\\Kelley\\ReportBuilder\\ExcelReportBuilder.cs:line 307" string


We currently have an app that automates excel and we are evaluating Syncfusion Excel Writer as an option.

Thanks

[Melba Winshia]

Hi rob,

Thank you for evaluating Syncfusion Essential XlsIO.

Would it be possible to provide me your sample xls file in which you are able to reproduce the issue? It will help me in investigating further on this issue.

Thanks,
Melba