如何在C＃中使用excel setsourcedata？ [英] How to use excel setsourcedata in C#?

问题描述

我正在开展一个excel项目，我在一个星期内在项目中遇到一个问题，请有人帮我这个，我用C＃编写代码来连接excel和更新数据，现在全部工作正常，最后一部分是新更新的数据应该出现在我的图表图表中，该图表存在于同一个Excel文件图表1中。我没有这个，请有人建议我。请检查下面的代码。我觉得我在setsourcedata上失败了，当我在宏中运行时我发现了这个。



我尝试了什么：

  //  宏观结果 
 ActiveSheet.ChartObjects（  Chart 1）。激活
 ActiveChart.SetSourceData Source：= Range（  Trd_NM！$ A $ 2：$ AC $ 7）
 ActiveChart.SetSourceData来源：=范围（  Trd_NM！$ A $ 2：$ AD $ 7 ）

  //  我试过的C＃代码 
 Excel.Workbook xlWorkBook; 
 Excel._Worksheet表; 
 Excel.ChartObject chartObj; 
 Excel._Chart chart; 
 Excel.Series系列; 
  object  useDefault = Type.Missing; 
 Excel.Workbook书; 
 xlWorkBook = app.Workbooks.Open（ @  E：\\\\\\ DC ）;  //  打开工作簿 
 sheet = xlWorkBook.Sheets [  Trd_NM];  //  选择图表所在的工作表 
 chart = sheet.ChartObjects（  Chart 1）。chart; 
 chart.PlotArea.Select（）; 
 chart.SetSourceData（sheet.Range [  A2：A7  ]，Excel.XlRowCol.xlColumns）;  

解决方案

A

2

AC

I'm working on a excel project and 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.

What I have tried:

// 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 which i have tried
               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:A7""], Excel.XlRowCol.xlColumns);

解决方案

A

2:

AC

这篇关于如何在C＃中使用excel setsourcedata？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！