更新时间:2022-11-03 08:40:19
签出
http://vb.net-informations.com/datagridview/vb.net_datagridview_import.htm [ ^ ]
VB.NET中的Excel连接 [ http://www.c-sharpcorner .com/uploadfile/ankurmee/import-data-from-excel-to-datagridview-in-C-Sharp/ [
Check out
http://vb.net-informations.com/datagridview/vb.net_datagridview_import.htm[^]
Excel Connectivity in VB.NET[^]
http://www.c-sharpcorner.com/uploadfile/ankurmee/import-data-from-excel-to-datagridview-in-C-Sharp/[^]
Dim MyConnection As System.Data.OleDb.OleDbConnection
Dim DtSet As System.Data.DataSet
Dim MyCommand As System.Data.OleDb.OleDbDataAdapter
MyConnection = New System.Data.OleDb.OleDbConnection("provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Txt_Path.Text.ToString() + ";Extended Properties=Excel 8.0;")
'MyConnection = New System.Data.OleDb.OleDbConnection("provider=Microsoft.Jet.OLEDB.4.0;Data Source='c:\vb.net-informations.xls';Extended Properties=Excel 8.0;")
MyCommand = New System.Data.OleDb.OleDbDataAdapter("select * from [Sheet1
",MyConnection中选择*) MyCommand.TableMappings.Add(" ," Net-informations.com") DtSet = 新建 System.Data.DataSet MyCommand.Fill(DtSet) dgv1.DataSource = DtSet.Tables( 0 ) MyConnection.Close()
", MyConnection) MyCommand.TableMappings.Add("Table", "Net-informations.com") DtSet = New System.Data.DataSet MyCommand.Fill(DtSet) dgv1.DataSource = DtSet.Tables(0) MyConnection.Close()