How to use Excel setsourcedata in C#?

I'm struggling with one problem in my project from one week , please someone help me for this , I have written code in C# for connecting excel and updating the data's , Now its all working fine , and the last part is the newly updated data should appear in my chart graph which is there in the same excel file "Chart 1" . i'm failing to this , please anybody suggest me .please check my code below . i think i'm failing at setsourcedata , and when i run it in macro i found this.

// Macro result

 ActiveSheet.ChartObjects("Chart 1").Activate

ActiveChart.SetSourceData Source:=Range("Trd_NM!$A$2:$AC$7")

 ActiveChart.SetSourceData Source:=Range("Trd_NM!$A$2:$AD$7")

<//C# code 
Excel.Workbook xlWorkBook;
 Excel._Worksheet sheet;
 Excel.ChartObject chartObj;
 Excel._Chart chart; 
Excel.Series series; 
object useDefault = Type.Missing; 
Excel.Workbook book;   
   xlWorkBook = app.Workbooks.Open(@"E:\\te\\DT");//Open the work book                
 sheet = xlWorkBook.Sheets["Trd_NM"];//Select the sheet the chart is on   
  chart = sheet.ChartObjects("Chart 1").chart;        
         chart.PlotArea.Select();             
    chart.SetSourceData(sheet.Range["A2:A6""], Excel.XlRowCol.xlColumns);
>

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

10y ago
Hello ,
I have removed the quotes and tried but there is no change in the result sir.
the data is showing in excel but the graph is not updating because of chart range in excel.

Midhun Tp10y ago

Hi,

In the provided code, there is an extra double quotes in SetSourceDate

 chart.SetSourceData(sheet.Range["A2:A6""], Excel.XlRowCol.xlColumns);

Try removing that -

 chart.SetSourceData(sheet.Range["A2:A6"], Excel.XlRowCol.xlColumns);