将特定列从Excel导出到Datagridview

using System;
using System.Data;
using System.Windows.Forms;
using System.Data.OleDb;

public void ImportExcelToDataGridView(string filePath, DataGridView dgv)
{
    try
    {
        // 连接字符串，这里假设Excel文件是.xlsx格式
        var connectionString = $"Provider=Microsoft.ACE.OLEDB.12.0;Data Source={filePath};Extended Properties='Excel 12.0 Xml;HDR=YES;'";

        // 使用 OleDb 连接
        using (OleDbConnection conn = new OleDbConnection(connectionString))
        {
            conn.Open();

            // SQL 查询，选择特定列
            // 假设要从名为Sheet1的工作表中选择A和C列
            OleDbDataAdapter adapter = new OleDbDataAdapter("SELECT [A], [C] FROM [Sheet1$]", conn);

            // 将数据填充到 DataTable
            DataTable dt = new DataTable();
            adapter.Fill(dt);

            // 设置 DataGridView 的数据源
            dgv.DataSource = dt;
        }
    }
    catch (Exception ex)
    {
        MessageBox.Show("Error: " + ex.Message);
    }
}

private void btnLoadData_Click(object sender, EventArgs e)
{
    string excelFilePath = @"C:\path\to\your\excel.xlsx";
    ImportExcelToDataGridView(excelFilePath, dataGridView1);
}