c# - 在 C# 中设置 Excel 图表轴标题颜色和大小

Question

我正在动态创建一些 Excel 图表数据/系列，并且无法设置轴标题字体颜色/大小。

我可以使用类似于下面的代码添加轴标题:

//Gets the WorkSheet and ChartObject
Worksheet DataSheet = (Worksheet)Template.Worksheets[1];
Chart Graph = (DataSheet.ChartObjects(1) as ChartObject).Chart;

//Gets the Axes
Axis Xaxis = Graph.Axes(XlAxisType.xlCategory, XlAxisGroup.xlPrimary) as Axis;
Axis Y1axis = Graph.Axes(XlAxisType.xlValue, XlAxisGroup.xlPrimary) as Axis;
Axis Y2axis = Graph.Axes(XlAxisType.xlValue, XlAxisGroup.xlSecondary) as Axis;

//Sets X-axis attributes
Xaxis.TickLabels.Font.Size = 8;
Xaxis.HasTitle = true;
Xaxis.AxisTitle.Text = "Current (A)";

//Sets Y-Primary Axis attributes
Y1axis.TickLabels.Font.Size = 8;
Y1axis.HasTitle = true;
Y1axis.AxisTitle.Text = "Power (W)";

//Sets Y-Secondary Axis attributes
Y2axis.TickLabels.Font.Size = 8;
Y2axis.HasTitle = true;
Y2axis.AxisTitle.Text = "Voltage (V)";

但我不知道颜色、字体大小、粗体等...属性在哪里。

Answer 1

经过几个小时的寻找，我找到了它。

Y1axis.AxisTitle.Format.TextFrame2.TextRange.Font.Fill.ForeColor.RGB = XlRgbColor.rgbDarkRed;

我只需要挖得更远一点。