使用VB.Net将excel中的特定列值导出到datagrid

Imports System.Data.OleDb

Dim connectionString As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=YourExcelFile.xlsx;Extended Properties=Excel 12.0"
Dim connection As New OleDbConnection(connectionString)
connection.Open()

Dim command As New OleDbCommand("SELECT ColumnName FROM [Sheet1$]", connection)
Dim adapter As New OleDbDataAdapter(command)
Dim dataTable As New DataTable()
adapter.Fill(dataTable)

connection.Close()

YourDataGrid.DataSource = dataTable
YourDataGrid.DataBind()