C# | Forms .NET |如何创建显示Excel工作表的ComboBox，然后将其显示在dataViewGrid中？

using Excel = Microsoft.Office.Interop.Excel;

private void Form1_Load(object sender, EventArgs e)
{
    Excel.Application excelApp = new Excel.Application();
    Excel.Workbook workbook = excelApp.Workbooks.Open("your_excel_file_path");
    
    foreach (Excel.Worksheet worksheet in workbook.Worksheets)
    {
        comboBox1.Items.Add(worksheet.Name);
    }
    
    workbook.Close();
    excelApp.Quit();
}

private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
    string selectedWorksheet = comboBox1.SelectedItem.ToString();
    
    Excel.Application excelApp = new Excel.Application();
    Excel.Workbook workbook = excelApp.Workbooks.Open("your_excel_file_path");
    Excel.Worksheet worksheet = workbook.Sheets[selectedWorksheet];
    Excel.Range range = worksheet.UsedRange;
    
    dataGridView1.Rows.Clear();
    dataGridView1.Columns.Clear();
    
    for (int i = 1; i <= range.Columns.Count; i++)
    {
        dataGridView1.Columns.Add("Column" + i, "Column" + i);
    }
    
    for (int i = 1; i <= range.Rows.Count; i++)
    {
        object[] values = new object[range.Columns.Count];
        
        for (int j = 1; j <= range.Columns.Count; j++)
        {
            values[j - 1] = range.Cells[i, j].Value;
        }
        
        dataGridView1.Rows.Add(values);
    }
    
    workbook.Close();
    excelApp.Quit();
}