1. Home
  2. Forum
  3. WinForms
  4. syncfusion exceltopdf convertor issue

syncfusion exceltopdf convertor issue

hi,

I have used syncfusion exceltopdf convertor to convert the below given datagrid and chart into pdf. But it is giving me this error.


 at Syncfusion.XlsIO.Implementation.Charts.ChartSerieImpl.OnNameChanged(String value)

   at Syncfusion.XlsIO.Implementation.Charts.ChartSerieImpl.set_Name(String value)

   at Syncfusion.XlsIO.Implementation.XmlSerialization.Charts.ChartParser.ParseSeriesText(XmlReader reader, ChartSerieImpl series)

   at Syncfusion.XlsIO.Implementation.XmlSerialization.Charts.ChartParser.ParseSeriesCommonWithoutEnd(XmlReader reader, ChartSerieImpl series, RelationCollection relations)

   at Syncfusion.XlsIO.Implementation.XmlSerialization.Charts.ChartParser.ParseLineSeries(XmlReader reader, ChartImpl chart, ExcelChartType seriesType, RelationCollection relations, Excel2007Parser parser)

   at Syncfusion.XlsIO.Implementation.XmlSerialization.Charts.ChartParser.ParseLineChartCommon(XmlReader reader, ChartImpl chart, Boolean is3D, RelationCollection relations, List`1 lstSeries, Excel2007Parser parser, ExcelChartType& chartType)

   at Syncfusion.XlsIO.Implementation.XmlSerialization.Charts.ChartParser.ParseLineChart(XmlReader reader, ChartImpl chart, RelationCollection relations, Dictionary`2 dictSeriesAxis, Excel2007Parser parser, ExcelChartType& chartType, List`1 markerArray)

   at Syncfusion.XlsIO.Implementation.XmlSerialization.Charts.ChartParser.ParsePlotAreaGeneral(XmlReader reader, ChartImpl chart, RelationCollection relations, Excel2007Parser parser)

   at Syncfusion.XlsIO.Implementation.XmlSerialization.Charts.ChartParser.ParsePlotArea(XmlReader reader, ChartImpl chart, RelationCollection relations, Excel2007Parser parser)

   at Syncfusion.XlsIO.Implementation.XmlSerialization.Charts.ChartParser.ParseChartElement(XmlReader reader, ChartImpl chart, RelationCollection relations)

   at Syncfusion.XlsIO.Implementation.XmlSerialization.Charts.ChartParser.ParseChart(XmlReader reader, ChartImpl chart, RelationCollection relations)

   at Syncfusion.XlsIO.Implementation.XmlReaders.Excel2007Parser.ParseChartTag(XmlReader reader, ChartImpl chart, RelationCollection relations, FileDataHolder dataHolder, String itemName, Boolean isChartEx)

   at Syncfusion.XlsIO.Implementation.XmlReaders.Excel2007Parser.TryParseChart(MemoryStream data, WorksheetBaseImpl sheet, String drawingPath, Boolean isChartEx)

   at Syncfusion.XlsIO.Implementation.XmlReaders.Excel2007Parser.ParseTwoCellAnchor(XmlReader reader, WorksheetBaseImpl sheet, String drawingsPath, List`1 lstRelationIds, Dictionary`2 dictItemsToRemove, Boolean isChartShape)

   at Syncfusion.XlsIO.Implementation.XmlReaders.Excel2007Parser.ParseDrawings(XmlReader reader, WorksheetBaseImpl sheet, String drawingsPath, List`1 lstRelationIds, Dictionary`2 dictItemsToRemove, Boolean isChartShape)

   at Syncfusion.XlsIO.Implementation.XmlSerialization.WorksheetDataHolder.ParseDrawings(WorksheetBaseImpl sheet, Relation drawingRelation, Dictionary`2 dictItemsToRemove, Boolean isChartShape)

   at Syncfusion.XlsIO.Implementation.XmlSerialization.WorksheetDataHolder.ParseDrawings(WorksheetBaseImpl sheet, String relationId, Dictionary`2 dictItemsToRemove)

   at Syncfusion.XlsIO.Implementation.XmlReaders.Excel2007Parser.ParseDrawings(XmlReader reader, WorksheetBaseImpl sheet, Dictionary`2 dictItemsToRemove)

   at Syncfusion.XlsIO.Implementation.XmlReaders.Excel2007Parser.ParseAfterSheetData(XmlReader reader, WorksheetImpl sheet, MemoryStream& streamCF, String strParentPath, Dictionary`2 dictItemsToRemove)

   at Syncfusion.XlsIO.Implementation.XmlReaders.Excel2007Parser.ParseSheet(XmlReader reader, WorksheetImpl sheet, String strParentPath, MemoryStream& streamStart, MemoryStream& streamCF, List`1 arrStyles, Dictionary`2 dictItemsToRemove, Dictionary`2 dictUpdatedSSTIndexes)

   at Syncfusion.XlsIO.Implementation.XmlSerialization.WorksheetDataHolder.ParseWorksheetData(WorksheetImpl sheet, Dictionary`2 dictUpdateSSTIndexes, Boolean parseOnDemand)

   at Syncfusion.XlsIO.Implementation.WorksheetImpl.ParseData(Dictionary`2 dictUpdatedSSTIndexes)

   at Syncfusion.XlsIO.Implementation.XmlReaders.Excel2007Parser.ParseWorksheets(Dictionary`2 dictUpdatedSSTIndexes, Boolean parseOnDemand)

   at Syncfusion.XlsIO.Implementation.XmlSerialization.FileDataHolder.ParseWorkbook(List`1& themeColors, Boolean parseOnDemand)

   at Syncfusion.XlsIO.Implementation.XmlSerialization.FileDataHolder.ParseDocument(List`1& themeColors, Boolean parseOnDemand)

   at Syncfusion.XlsIO.Implementation.WorkbookImpl.ParseExcel2007Stream(Stream stream, String password, Boolean parseOnDemand)

   at Syncfusion.XlsIO.Implementation.WorkbookImpl.ParseStream(Stream stream, String password, ExcelVersion version, ExcelParseOptions options)

   at Syncfusion.XlsIO.Implementation.WorkbookImpl..ctor(IApplication application, Object parent, Stream stream, ExcelParseOptions options, ExcelVersion version)

   at Syncfusion.XlsIO.Implementation.ApplicationImpl.CreateWorkbook(Object parent, Stream stream, ExcelVersion version, ExcelParseOptions options)

   at Syncfusion.XlsIO.Implementation.Collections.WorkbooksCollection.Open(Stream stream, ExcelVersion version, ExcelParseOptions options)

   at Syncfusion.XlsIO.Implementation.Collections.WorkbooksCollection.Open(Stream stream, ExcelOpenType openType, String fileName, ExcelVersion version, ExcelParseOptions options)

   at Syncfusion.XlsIO.Implementation.Collections.WorkbooksCollection.Open(String fileName, ExcelOpenType openType, ExcelVersion version, ExcelParseOptions options)

   at Syncfusion.XlsIO.Implementation.Collections.WorkbooksCollection.Open(String fileName, ExcelOpenType openType)

   at PCT.SPC.SpcCockpit.btnExportExcel_Click(Object sender, EventArgs e) in E:\RS_Projects\SPC_JaiHind_old\SPC\SpcCockpit.cs:line 1115



How To fix this issue?

Thanks 

Raksha 



8 Replies
KK Konduru Keerthi Konduru Ravichandra Raju Syncfusion Team January 3, 2022 11:57 AM UTC

Hi Raksha, 

Greetings from Syncfusion. 

Kindly share the Excel document you are using at your end and confirm us the Syncfusion XlsIO version, which will be helpful for us in investing the query and provide prompt solution at the earliest. 

Regards, 
Keerthi.

RA Raksha January 3, 2022 01:03 PM UTC

The syncfusion version I'm using is 19.4.0.40

Please find the attached excel document.



Attachment: MivinProcessControl_33df821f.zip

KK Konduru Keerthi Konduru Ravichandra Raju Syncfusion Team January 4, 2022 12:56 PM UTC

Hi Raksha, 

Thanks for sharing the file and confirming the version.  

We are able to reproduce the reported issue and validating it currently. We will share the validation details on January 6th,2022. 

Regards, 
Keerthi. 


KK Konduru Keerthi Konduru Ravichandra Raju Syncfusion Team January 6, 2022 01:28 PM UTC

Hi Raksha, 
 
We appreciate your patience. 

We have confirmed the issue as Exception is thrown while opening Excel document when chart series name has string formula and logged a defect report. We will include the fix for this issue in our upcoming weekly NuGet release scheduled for January 18th, 2022. 

You can track the status of defect report through following feedback link. 

We will let you know once the new package version is available on nuget.org. 

Regards, 
Ramya. 


RA Raksha January 7, 2022 03:41 AM UTC

Hi,


Okay ma'am Thank you.


Regards,

Raksha



KK Konduru Keerthi Konduru Ravichandra Raju Syncfusion Team January 7, 2022 03:54 AM UTC

Hi Raksha, 

You are Welcome. 

Regards, 
Keerthi. 


KK Konduru Keerthi Konduru Ravichandra Raju Syncfusion Team January 18, 2022 06:31 AM UTC

Hi Raksha, 
 
We deeply regret for the inconvenience. 
 
We were unable to move the fix for Exception is thrown while opening Excel document when chart series name has string formula in our weekly NuGet release, as promised. We will include the fix in our next weekly NuGet release scheduled for January 25th, 2022, without fail. 
 
We will let you know once the package is available to download from nuget.org. 
 
We appreciate your patience. 
 
Regards, 
Keerthi. 


KK Konduru Keerthi Konduru Ravichandra Raju Syncfusion Team January 25, 2022 04:35 PM UTC

Hi Raksha, 
 
We appreciate your patience. 

We have included the fix to resolve the issue Exception is thrown while opening Excel document when chart series name has string formula in our weekly NuGet release version 19.4.0.47. Kindly upgrade your Syncfusion packages to this new 19.4.0.47 version and let us know if the issue is resolved. 

Regards, 
Ramya. 


Loader.
Up arrow icon