We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

Display charts in the spreadsheet control?

Thread ID:

Created:

Updated:

Platform:

Replies:

125733 Sep 7,2016 12:04 PM Sep 8,2016 08:06 AM Windows Forms 1
loading
Tags: Spreadsheet
Travis Chambers
Asked On September 7, 2016 12:04 PM

Online documentation mentions that the spreadsheet control supports various data visualizations including charts. However, opening an existing excel file with charts fails to display the charts and instead shows a null reference exception. I have also tried creating a chart grammatically using the IChartShape, but to no avail.

Is there any way to display charts in the sfspreadsheet? 

Kanimozhi Bharathi [Syncfusion]
Replied On September 8, 2016 08:06 AM

Hi Travis Chambers, 
 
Thank you for contacting Syncfusion Support. 
 
Please find the below details 
 
QUERY 
RESPONSE 
Online documentation mentions that the spreadsheet control supports various data visualizations including charts. However, opening an existing excel file with charts fails to display the charts and instead shows a null reference exception. I have also tried creating a chart grammatically using the IChartShape, but to no avail 
To import chart into Spreadsheet, you need to add “ Syncfusion.SpreadsheetHelper.Windows.dll” assembly as reference and create an instance of Syncfusion.Windows.Forms.SpreadsheetHelper.GraphicChartCellRenderer and add that renderer into GraphicCellRenderers  collection by using the helper method AddGraphicChartCellRenderer which is available under the namespace “Syncfusion.Windows.Forms.Spreadsheet.GraphicCells”  like the below code example, 
 
 
public MainWindow()
{
  InitializeComponent();
  //For importing charts, 
  this.spreadsheet.AddGraphicChartCellRenderer(new GraphicChartCellRenderer());
} 
 
Is there any way to display charts in the sfspreadsheet? 
 
Please find the below UG links to display charts in SfSpreadsheet/Spreadsheet, 
 
For SfSpreadsheet(WPF), 
 
 
 
For Spreadsheet(WindowsForms) 
 
 
 
If still you have problem in displaying charts, could you please share the excel file? 
 
Regards 
Kanimozhi B 


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.

;