需要从SSIS包在excel中着色标题

using System;
using System.Data;
using Microsoft.SqlServer.Dts.Runtime;
using System.Windows.Forms;
using Microsoft.Office.Interop.Excel;

public void Main()
{
    string excelFilePath = @"C:\path\to\your\excel\file.xlsx";
    string sheetName = "Sheet1";
    int titleRow = 1;
    
    // Create a new Excel application
    Application excelApp = new Application();
    
    // Open the Excel workbook
    Workbook workbook = excelApp.Workbooks.Open(excelFilePath);
    
    // Get the specified worksheet
    Worksheet worksheet = (Worksheet)workbook.Sheets[sheetName];
    
    // Get the range of the title row
    Range titleRange = worksheet.Rows[titleRow];
    
    // Set the title row background color to yellow
    titleRange.Interior.Color = XlRgbColor.rgbYellow;
    
    // Save the changes to the Excel file
    workbook.Save();
    
    // Close the workbook and the Excel application
    workbook.Close();
    excelApp.Quit();
    
    Dts.TaskResult = (int)ScriptResults.Success;
}