![]() |
#2
jianjunfeng2014-05-19 12:19
回复 楼主 lin7516
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim OPEN As New OpenFileDialog : Dim filea As String Me.DataGridView1.DataSource = Nothing Me.DataGridView1.Rows.Clear() Me.DataGridView1.Columns.Clear() 'OPEN.InitialDirectory = OPEN.Filter = "excel files (*.xls)|*.xls" OPEN.FilterIndex = 1 OPEN.RestoreDirectory = True If OPEN.ShowDialog() = Windows.Forms.DialogResult.OK Then Dim fileName As String fileName = OPEN.FileName '建立EXCEL连接,读入数据 Dim strConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source='" & fileName & "';Extended Properties=Excel 8.0;" Dim myDataset As New DataSet If ComboBox2.SelectedIndex > 0 Then filea = Trim(ComboBox2.Text) Else filea = Mid(fileName, InStrRev(fileName, "\", -1, 1) + 1, Len(fileName)) Dim aa As Integer = InStr(1, filea, ".") filea = Mid(filea, 1, aa - 1) End If Dim fileB As String = "SELECT * FROM [" & filea & "$]" Dim da As New OleDb.OleDbDataAdapter(fileB, strConn) Try da.Fill(myDataset) Me.DataGridView1.DataSource = myDataset.Tables(0) Me.Button2.Enabled = True Catch ex As Exception MsgBox(ex.Message.ToString) Me.Button2.Enabled = False End Try End If End Sub 只有本站会员才能查看附件,请 登录 |
请问怎样把EXCEL数据写入datagridview1啊。谢谢!!!
还有我编辑了datagridview1的列,可是加载数据时,datagridview1却自动添加了列,我编辑的列却是空的,请问怎么加载到自己的列上去啊。
[ 本帖最后由 lin7516 于 2014-3-17 14:53 编辑 ]