为什么VB.NET中的DataGrid不能完整显示Excel数据？

Question

我正在使用下面的源代码在VB.Net中开发我的应用程序，但我得到的问题是，数据不能完全显示在DataGridView中。

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
    Dim conn As OleDb.OleDbConnection
    Dim dta As OleDb.OleDbDataAdapter
    Dim dts As DataSet
    Dim excelpath As String

    Dim ExcelQuery As String = "Select * From [IOT_NOVA$B12:S257]"

    Try

        If TextBox1.Text = "" Then
            MsgBox("Please select Excel file to upload!", vbExclamation)
            Exit Sub
        End If

        excelpath = TextBox1.Text
        conn = New OleDb.OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + excelpath + ";Extended Properties='Excel 12.0;HDR=YES;IMEX=1';")
        dta = New OleDb.OleDbDataAdapter(ExcelQuery, conn)

        DtSet = New DataTable
        dta.Fill(DtSet)


        DataGridView1.DataSource = DtSet
        
        conn.Close()
        conn.Dispose()

    Catch ex As Exception
        MsgBox(ex.Message, vbCritical)
    End Try

End Sub

Answer 1

在设置DataGridview的DataSource时，需要设置表名。

DataGridView1.DataSource = DtSet.Tables(0)

或

DataGridView1.DataSource = DtSet.Tables("IOT_NOVA")

Answer 2

您可能遇到默认列框大小的问题。查看这个问题：How to set max length of datagridview column编辑:发现另一个问题- excel数据驱动程序有错误。看看下面这个帖子：How do I create an Excel (.XLS and .XLSX) file in C# without installing Microsoft Office?