''-----------------------------------------代码导入数据-----------------------------------------
'Dim dlg As New OpenFileDialog '定义一个新的OpenFileDialog
'dlg.Filter= "Excel文件|*.xls" '设置筛选器
'If dlg.ShowDialog = DialogResult.Ok Then '如果用户单击了确定按钮
'MessageBox.Show("你选择的是:" & dlg.FileName,"提示") '提示用户选择的文件
'End If
'-------------------------------------------------- -上下怎样结合起来呢?----------------
'Dim Book As New XLS.Book("c:\test\考勤记录.xls")
'Dim Sheet As XLS.Sheet = Book.Sheets(0)
'Tables("当月刷脸").StopRedraw()
''注意以下数组中列名称的顺序,必须和Excel表中的列顺序一致
'Dim nms() As String = {"员工号","姓名","所属部门","D1","D2","D3","D4","D5","D6","D7"
''注意下面的循环变量从1开始,而不是从0开始,因为Excel表的第一行是标题
'For n As Integer = 1 To Sheet.Rows.Count -1
'Dim r As Row = Tables("当月刷脸").AddNew()
'For m As Integer = 0 To nms.Length - 1
'r(nms(m)) = Sheet(n,m).Value
'Next
'Next
'Tables("当月刷脸").ResumeRedraw()
''End If