注册 登录
编程论坛 VB.NET论坛

请问VB.net怎样把EXCEL数据写入datagridview1啊。

lin7516 发布于 2014-03-17 10:16, 718 次点击
  请问怎样把EXCEL数据写入datagridview1啊。谢谢!!!
还有我编辑了datagridview1的列,可是加载数据时,datagridview1却自动添加了列,我编辑的列却是空的,请问怎么加载到自己的列上去啊。

[ 本帖最后由 lin7516 于 2014-3-17 14:53 编辑 ]
2 回复
#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
只有本站会员才能查看附件,请 登录
#3
worte2014-05-23 15:22
还有我编辑了datagridview1的列,可是加载数据时,datagridview1却自动添加了列,我编辑的列却是空的,请问怎么加载到自己的列上去啊。


我也想知道这是怎么一回事?
1