如何在DataGridView中用Excel头显示完整的Excel数据？当我将标题放在OleDB连接上时，单元格变为空

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

// 1. 使用OleDb连接读取Excel文件数据并填充到DataTable对象
string connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=path_to_excel_file;Extended Properties='Excel 12.0;HDR=YES;'";
string query = "SELECT * FROM [Sheet1$]";
DataTable dataTable = new DataTable();

using (OleDbConnection connection = new OleDbConnection(connectionString))
{
    using (OleDbDataAdapter adapter = new OleDbDataAdapter(query, connection))
    {
        adapter.Fill(dataTable);
    }
}

// 2. 将DataTable对象绑定到DataGridView控件上
dataGridView.DataSource = dataTable;

// 3. 使用Excel文件中的第一行作为DataGridView的列标题
for (int i = 0; i < dataTable.Columns.Count; i++)
{
    dataGridView.Columns[i].HeaderText = dataTable.Rows[0][i].ToString();
}

// 4. 自动调整列宽
dataGridView.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells);