如何将特定的数据从Excel工作表导入到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