获取图表趋势线的方程文本

你可以使用Aspose.Cells for Python via .NET检索图表趋势线的方程文本。Aspose.Cells for Python via .NET提供了返回图表趋势线方程文本的属性。要使用此属性，您首先需要调用Chart.calculate()方法。

下图显示了有趋势线的图表，其方程文本以红色显示。我们将使用Trendline.data_labels.text属性来检索这个文本，在以下示例代码中。

获取图表趋势线的方程文本的C#代码

from aspose.cells import Workbook

#  For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET
#  The path to the documents directory.
dataDir = RunExamples.GetDataDir(".")
#  Create workbook object from source Excel file
workbook = Workbook(dataDir + "source.xlsx")
#  Access the first worksheet
worksheet = workbook.worksheets[0]
#  Access the first chart inside the worksheet
chart = worksheet.charts[0]
#  Calculate the Chart first to get the Equation Text of Trendline
chart.calculate()
#  Access the Trendline
trendLine = chart.n_series[0].trend_lines[0]
#  Read the Equation Text of Trendline
print("Equation Text: "  + trendLine.data_labels.text)

示例代码生成的输出

这是上述示例代码的控制台输出。

Equation Text: y = 8.1333x + 5