如何将特定的数据从Excel工作表导入到DataGridView? [英] How to Import Specific Data from Excel Sheet to DataGridView ?

问题描述

我想将数据从A列导入到H列，并将数据从第14行导入到末尾..

打开Excel文件并将数据从特定单元格"导入到下面的文本框"和"DateTimePicker"中的代码.

I want to import Data from Column A to Column H and from Row 14 to the end ..

the code for open excel file and import data from Specific Cells to Textbox and DateTimePicker below ..

Dim SourceBookPath As String = Nothing
        Me.OpenFileDialog1.Filter = "Excel files (*.xls,*.xlsx)|*.xls;*.xlsx"
        Me.OpenFileDialog1.ShowDialog()
        If Not Me.OpenFileDialog1.FileName Is Nothing Then
            SourceBookPath = Me.OpenFileDialog1.FileName
        End If

        '=========================================================

        Dim MsExcel = CreateObject("Excel.Application")
        Dim ExcelBook = MsExcel.Workbooks.Open(SourceBookPath)
        Try
            TextBox1.Text = MsExcel.Cells(6, 2).Value
            TextBox2.Text = MsExcel.Cells(6, 4).Value
            DateTimePicker1.Text = MsExcel.Cells(6, 6).Value
            TextBox4.Text = MsExcel.Cells(6, 8).Value
            TextBox5.Text = MsExcel.Cells(8, 2).Value
            DateTimePicker2.Text = MsExcel.Cells(8, 4).Value
            TextBox7.Text = MsExcel.Cells(8, 6).Value
            TextBox8.Text = MsExcel.Cells(8, 8).Value
            DateTimePicker3.Text = MsExcel.Cells(11, 2).Value

            '=========================================================


            '=========================================================

            ExcelBook.Close(False)
            ExcelBook = Nothing
            MsExcel.Quit()
            MsExcel = Nothing
            MsgBox("Data Importing OK!", MsgBoxStyle.Information)
        Catch ex As Exception
            ExcelBook.Close(False)
            ExcelBook = Nothing
            MsExcel.Quit()
            MsExcel = Nothing
            MsgBox(ex.Message)
        End Try

我只想要将数据导入到DataGridView的代码，并且必须与上面的代码兼容..

非常感谢.

I just want the code for importing data to DataGridView and must be compatible with the code above..

Thanks a lot .

推荐答案

喜欢吗?

http://vb.net-informations.com/datagridview/vb.net_datagridview_import.htm [ ^ ]

Like this?

http://vb.net-informations.com/datagridview/vb.net_datagridview_import.htm[^]

现在我正在创建一个用于在WPF中输入候选人详细信息的gui，并将全部输入的数据存储在excel工作表中，但是根据候选人姓名/电子邮件成功搜索后，我想在我的搜索窗口中显示受人尊敬的excel结果.任何人都可以帮助我紧急

Now i am creating one gui for entering candidate details in WPF and i stored the whole entered data in excel sheet,but after successful search based on candidate Name/Email i want display respected excel result in my search window.. please any one help me its urgent

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