Convert a ChartControl to an Excel chart

[Baffelli]

I want put my ChartControl in a GridControl and also want to export the grid to Excel converting the Syncfusion ChartControl to an Excel Chart control. Is it possible?

Best regards, Baffelli.

[Melba Winshia]

Hi Baffelli,

Currently we do not provide support for converting the Syncfusion ChartControl to an Excel Chart control. However, you can export Essential Chart to an Excel spreadsheet as an image. Could you please refer this KB article to export Essential Chart to an Excel Spreadsheet?

http://www.syncfusion.com/support/kb/chart/Default.aspx?ToDo=view&questId=9

Could you please refer this KB article to export the contents of Essential Grid to Excel?

http://www.syncfusion.com/support/kb/xlsio/Default.aspx?ToDo=view&questId=5

Please take a look and let me know if you have any other questions.

Thanks,
Melba

[Baffelli]

Thank you for the reply, was very useful.
I have only one question: can I put a ChartControl into a GridControl's cell? How can I do this?

Regards, Baffelli.

[Melba Winshia]

Hi Bafelli,

Yes, you can export chart to a grid control. Here is the sample for your reference:

ChartExport.zip

Please take a look at the sample above and let me know if you have any other questions.

Thanks,
Melba

[Baffelli]

Your example explains how to export a GridControl to Excel. I want to put a ChartControl in a cell of a GridControl. Is it possible?

Regards, Baffelli.

[Administrator]

Hi Baffelli,

To have a chart control in a grid cell, you need to use the Control cell type.

//
this.gridControl1[2, 2].CellType = "Control";

this.gridControl1[2, 2].Control = mychartControl;

this.gridControl1.Controls.Add(mychartControl);
//

Please refer this forum thread,
http://www.syncfusion.com/support/Forums/message.aspx?MessageID=28478

Regards,
Rajagopal

[Baffelli]

Thanks a lot for your support, was veey useful!

Regards, Baffelli

[Administrator]

Hi Baffelli,

Thanks for the update!

Best Regards,
Melba