如何将数据从Excel工作表导入到vb.net中的datagridview? [英] How to import data from excel sheet to datagridview in vb.net?

问题描述

如何将数据从Excel工作表导入vb.net中的datagridview?

How to import data from excel sheet to datagridview in vb.net?

推荐答案

签出
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()

这篇关于如何将数据从Excel工作表导入到vb.net中的datagridview?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！