首页 \ 问答 \ 如何在C＃中获取图表的Excel XValue(How to get Excel XValue of a Chart in C#)

如何在C＃中获取图表的Excel XValue(How to get Excel XValue of a Chart in C#)

 
 我正在编写一些代码来使用C＃操作excle文件中的图表。 其中一个关键要求是获取Chart SeriesCollection的XValue属性。 我试图通过索引访问它，但它不起作用，虽然我可以在Visual Studio的Watch窗口中看到值列表。 从Watch窗口，我注意到s.XValue的类型是动态{object []} ，我之前从未见过它，而obj.ToString（）是System.Object [*] 。 问题是如果XValue不支持索引，我如何从XValue属性中获取每个值。  

 
 顺便说一句，在互联网上搜索，我只能找到将excel单元格范围设置为XValue的方法，但是没有找到如何获得XValue。 如果有人可以提供建议，我真的很感激。  
 
Excel._Worksheet worksheet = (Excel._Worksheet)book.Worksheets[a];
Excel.ChartObject chartObj = (Excel.ChartObject)worksheet.ChartObjects(1);
if (chartObj != null)
{
   Excel.Chart chart = (Excel.Chart)chartObj.Chart;
   var s = (Excel.Series)chart.SeriesCollection(1);
   object obj = s.XValues;
   //How to get s.XValues[1], s.XValues[2], s.XValues[3]...
}

 
I am writing some codes to manipulate a chart in excle file using C#. One of the key requirements is to get XValue property of a Chart SeriesCollection. I tried to visit it by index, however it doesn't work, although I can see the value list in Watch window in Visual Studio. From the Watch window, I noticed the type of s.XValue is dynamic{object[]} which I never met before, and obj.ToString() is System.Object[*]. The question is how I can get each value from XValue property if XValue DON'T support index. 

 
By the way, searching on the Internet, I can only find ways to set excel cell range to XValue, but didn't find how to get the XValue. I really appreciate if anyone can advise. 
 
Excel._Worksheet worksheet = (Excel._Worksheet)book.Worksheets[a];
Excel.ChartObject chartObj = (Excel.ChartObject)worksheet.ChartObjects(1);
if (chartObj != null)
{
   Excel.Chart chart = (Excel.Chart)chartObj.Chart;
   var s = (Excel.Series)chart.SeriesCollection(1);
   object obj = s.XValues;
   //How to get s.XValues[1], s.XValues[2], s.XValues[3]...
}

原文：https://stackoverflow.com/questions/27486962

更新时间：2022-05-24 16:05

最满意答案

 如果数字长度为0，则应在循环外添加一个return语句，因此它永远不会进入for函数。  
private static String HighOrLow (int[] numbers){
 for (int i = 0; i < numbers.length; i++) {
    if (numbers[i] > average) {
         return (numbers[i] + "is above the average");
    }
    else if (numbers[i] < average) {
         return (numbers[i] + " is below the average");
    }
    else   {
         return (numbers[i] + " is equal to the average");
   }
  }
  return "No numbers founds";
}
 
 同样按照惯例，方法应该以小写的第一个字母开头：  
 
  方法应该是动词，在第一个字母小写的大小写混合的情况下，每个内部单词的首字母大写。  

You should add a return statement outside the loop in case numbers length is 0, so it will never enter inside your for function.  
private static String HighOrLow (int[] numbers){
 for (int i = 0; i < numbers.length; i++) {
    if (numbers[i] > average) {
         return (numbers[i] + "is above the average");
    }
    else if (numbers[i] < average) {
         return (numbers[i] + " is below the average");
    }
    else   {
         return (numbers[i] + " is equal to the average");
   }
  }
  return "No numbers founds";
}
 
Also by convention methods should start with the first letter lowercase: 
 
 Methods should be verbs, in mixed case with the first letter lowercase, with the first letter of each internal word capitalized.

如何在C＃中获取图表的Excel XValue(How to get Excel XValue of a Chart in C#)

最满意答案

相关问答

Java mockito - 如何在循环中添加return语句？(Java mockito - how to add return statement in a loop?)[2023-03-01]

如何使用while循环在java中创建搜索语句，并在找到对象时停止并返回该对象(How do I make a search statement in java with a while loop and stop and return the object when it's found)[2022-08-25]

将return语句添加到Java中的可监视(Adding return statement to watchable in Java)[2022-01-02]

Java仅在循环内返回值(Java return value only from within a loop)[2022-03-25]

while循环在Java中的if语句(while loop in if statement in java)[2021-08-19]

使用return语句时循环不会中断(loop is not breaking when return statement used)[2022-04-09]

return语句如何在以下java方法中工作？(How is the return statement working in the following java method?)[2022-09-24]

JAVA：if语句在for循环内并退出for循环(JAVA: if statement inside a for loop and exiting from a for loop)[2022-10-02]

在Java中使用for循环时如何实现return语句？(How to implement a return statement when using a for loop in Java?)[2023-12-13]

（（Java）if if后面的return语句if / else循环？(((Java) Return statement after if/else if/else loop?)[2023-09-15]

相关文章

最新问答