下载信息  [文件大小：   下载次数： ]

点击浏览该文件:参评一览.xls

Dim Result As DialogResult
Result = MessageBox.Show("确定要导入吗?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question)
If Result = DialogResult.Yes Then
    Dim dlg As New OpenFileDialog
    dlg.Filter = "Excel文件|*.xls"
    dlg.MultiSelect = True \'允许选择多个文件
    If dlg.ShowDialog =DialogResult.OK Then
        Dim Book As New XLS.Book(dlg.FileName)
        Dim Sheet As XLS.Sheet = Book.Sheets(0)
        Tables("上会评审表").ResumeRedraw()
        Tables("上会评审表").StopRedraw()
        systemready = False
        Dim nms() As String = {"评审分组","工作单位","县公司","材料编号","姓名","性别","身份证号码","文化程度","现岗位名称","参加工作时间","现工种工作时间","原技术资格等级","原等级取得时间","原资格证书工种","原资格证书编号","鉴定等级","申报鉴定工种","鉴定批次","申报性质","理论成绩","实操成绩","工作业绩","潜能成绩","总评成绩","评审资格","备注"}
        Dim dic As new Dictionary(Of DataRow, Integer)
        Dim ls As new List(Of Integer)
        For n As Integer = 1 To Sheet.Rows.Count -1
            Dim sfzhm As String = sheet(n,7).Text
            Dim jdpc As String = sheet(n,18).Text
            Dim dr As DataRow = DataTables("上会评审表").Find("身份证号码 = \'" & sfzhm & "\' And 鉴定批次 = \'" & jdpc & "\'")
            If dr Is Nothing Then
                ls.add(n)
            Else
                dic.Add(dr, n)
            End If
        Next
        For Each key As DataRow In dic.Keys
            For m As Integer = 0 To nms.Length - 1
                If DataTables("上会评审表").DataCols(nms(m)).IsBoolean Then
                    If Sheet(dic(key),m).Value = 0 Then
                        key(nms(m)) = False
                    Else
                        key(nms(m)) = True
                    End If
                Else If DataTables("上会评审表").DataCols(nms(m)).Expression > "" Then
                    \'表达式列
                Else If DataTables("上会评审表").DataCols(nms(m)).IsNumeric Then
                    key(nms(m)) = val(Sheet(dic(key),m).Value)
                Else
                    key(nms(m)) = Sheet(dic(key),m).Value
                End If
            Next
        Next
        For Each l As Integer In ls
            Dim ndr As DataRow = DataTables("上会评审表").AddNew
           
            For m As Integer = 0 To nms.Length - 1
                If DataTables("上会评审表").DataCols(nms(m)).IsBoolean Then
                    If Sheet(l,m).Value = 0 Then
                        ndr (nms(m)) = False
                    Else
                        ndr (nms(m)) = True
                    End If
                Else If DataTables("上会评审表").DataCols(nms(m)).Expression > "" Then
                    \'表达式列
                Else If DataTables("上会评审表").DataCols(nms(m)).IsNumeric Then
                    ndr (nms(m)) = val(Sheet(l,m).Value)
                Else
                    ndr (nms(m)) = Sheet(l,m).Value
                End If
            Next
        Next
        Tables("上会评审表").ResumeRedraw()
        systemready = True
    End If
End If

这是“导入”按钮代码，现在就是点按钮就报错，不知是为什么？求版主指点，谢谢先！！！！！！

请把excel数据和foxtable例子一起发上来测试。

代码没问题，这段代码，必须和excel表的各个列对应。

Dim nms() As String = {"评审分组","工作单位","县公司","材料编号","姓名","性别","身份证号码","文化程度","现岗位名称","参加工作时间","现工种工作时间","原技术资格等级","原等级取得时间","原资格证书工种","原资格证书编号","鉴定等级","申报鉴定工种","鉴定批次","申报性质","理论成绩","实操成绩","工作业绩","潜能成绩","总评成绩","评审资格","备注"}

汗

Dim Result As DialogResult
Result = MessageBox.Show("确定要导入吗?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question)
If Result = DialogResult.Yes Then
    Dim dlg As New OpenFileDialog
    dlg.Filter = "Excel文件|*.xls"
    dlg.MultiSelect = True \'允许选择多个文件
    If dlg.ShowDialog =DialogResult.OK Then
        Dim Book As New XLS.Book(dlg.FileName)
        Dim Sheet As XLS.Sheet = Book.Sheets(0)
        Tables("上会评审表").ResumeRedraw()
        Tables("上会评审表").StopRedraw()
        systemready = False     
        Dim nms() As String = {"","评审分组","工作单位","县公司","材料编号","姓名","性别","身份证号码","文化程度","现岗位名称","参加工作时间","现工种工作时间","原技术资格等级","原等级取得时间","原资格证书工种","原资格证书编号","鉴定等级","申报鉴定工种","鉴定批次","申报性质","理论成绩","实操成绩","工作业绩","潜能成绩","总评成绩","备注"}
        Dim dic As new Dictionary(Of DataRow, Integer)
        Dim ls As new List(Of Integer)
        For n As Integer = 1 To Sheet.Rows.Count -1
            Dim sfzhm As String = sheet(n,7).Text
            Dim jdpc As String = sheet(n,18).Text
            Dim dr As DataRow = DataTables("上会评审表").Find("身份证号码 = \'" & sfzhm & "\' And 鉴定批次 = \'" & jdpc & "\'")
            If dr Is Nothing Then
                ls.add(n)
            Else
                dic.Add(dr, n)
            End If
        Next
        For Each key As DataRow In dic.Keys
            For m As Integer = 0 To nms.Length - 1
                If nms(m) = "" Then Continue For
                output.show(m)
                If DataTables("上会评审表").DataCols(nms(m)).IsBoolean Then
                    If Sheet(dic(key),m).Value = 0 Then
                        key(nms(m)) = False
                    Else
                        key(nms(m)) = True
                    End If
                Else If DataTables("上会评审表").DataCols(nms(m)).Expression > "" Then
                    \'表达式列
                Else If DataTables("上会评审表").DataCols(nms(m)).IsNumeric Then
                    key(nms(m)) = val(Sheet(dic(key),m).Value)
                Else If DataTables("上会评审表").DataCols(nms(m)).IsDate Then
                    Dim d As Date
                    If Date.TryParse(Sheet(dic(key),m).Value, d)
                        key(nms(m)) = d
                    End If
                Else
                    key(nms(m)) = Sheet(dic(key),m).Value
                End If
            Next
        Next
        For Each l As Integer In ls
            Dim ndr As DataRow = DataTables("上会评审表").AddNew
           
            For m As Integer = 0 To nms.Length - 1
                If nms(m) = "" Then Continue For
                If DataTables("上会评审表").DataCols(nms(m)).IsBoolean Then
                    If Sheet(l,m).Value = 0 Then
                        ndr (nms(m)) = False
                    Else
                        ndr (nms(m)) = True
                    End If
                Else If DataTables("上会评审表").DataCols(nms(m)).Expression > "" Then
                    \'表达式列
                Else If DataTables("上会评审表").DataCols(nms(m)).IsNumeric Then
                    ndr (nms(m)) = val(Sheet(l,m).Value)
                Else If DataTables("上会评审表").DataCols(nms(m)).IsDate Then
                    Dim d As Date
                    If Date.TryParse(Sheet(l,m).Value, d)
                        ndr (nms(m)) = d
                    End If
                Else
                    ndr (nms(m)) = Sheet(l,m).Value
                End If
            Next
        Next
        Tables("上会评审表").ResumeRedraw()
        systemready = True
    End If
End If