C#使用Excel Interop添加辅助轴

using Excel = Microsoft.Office.Interop.Excel;

// 创建Excel应用程序对象
Excel.Application excelApp = new Excel.Application();

// 打开已存在的Excel文件
Excel.Workbook workbook = excelApp.Workbooks.Open("文件路径");

// 或创建新的Excel文件
Excel.Workbook workbook = excelApp.Workbooks.Add();

// 获取第一个工作表
Excel.Worksheet worksheet = workbook.Worksheets[1];

// 创建图表对象
Excel.ChartObjects chartObjects = worksheet.ChartObjects();
Excel.ChartObject chartObject = chartObjects.Add(100, 100, 400, 300);

// 设置图表类型为散点图
Excel.Chart chart = chartObject.Chart;
chart.ChartType = Excel.XlChartType.xlXYScatter;

// 获取图表的坐标轴集合
Excel.Axes axes = chart.Axes();

// 添加辅助轴
Excel.Axis secondaryAxis = axes[Excel.XlAxisType.xlSecondary];
secondaryAxis.HasTitle = true;
secondaryAxis.AxisTitle.Text = "辅助轴标题";

// 保存Excel文件
workbook.SaveAs("保存路径");

// 关闭Excel文件
workbook.Close();

// 释放资源
System.Runtime.InteropServices.Marshal.ReleaseComObject(secondaryAxis);
System.Runtime.InteropServices.Marshal.ReleaseComObject(axes);
System.Runtime.InteropServices.Marshal.ReleaseComObject(chart);
System.Runtime.InteropServices.Marshal.ReleaseComObject(chartObject);
System.Runtime.InteropServices.Marshal.ReleaseComObject(chartObjects);
System.Runtime.InteropServices.Marshal.ReleaseComObject(worksheet);
System.Runtime.InteropServices.Marshal.ReleaseComObject(workbook);
System.Runtime.InteropServices.Marshal.ReleaseComObject(excelApp);