If e.Form.Controls("DropBox1").text > "" Then
    Dim dlg As New OpenFileDialog \'定义一个新的OpenFileDialog
    dlg.Filter= "Excel文件|*.xls;*.xlsx" \'设置筛选器
    dlg.InitialDirectory =  "d:\\king\\"
   
    If dlg.ShowDialog = DialogResult.Ok Then \'如果用户单击了确定按钮
        e.Form.Controls("But生成表").performclick
        Dim tb As Table = Tables(Vars("TbName"))

        \'~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
        Dim Book As New XLS.Book(dlg.FileName)
        Dim Sheet As XLS.Sheet = Book.Sheets(0)
        tb.StopRedraw()
        \'注意以下数组中列名称的顺序,必须和Excel表中的列顺序一致
        Dim nms() As String = {"Comment","Footprint","Quantity"}
        \'注意下面的循环变量从1开始,而不是从0开始,因为Excel表的第一行是标题
        For n As Integer = 1 To Sheet.Rows.Count -1
            Dim r As Row = tb.AddNew()
            For m As Integer = 0 To nms.Length - 1
                r(nms(m)) = Sheet(n,m).Value
            Next
        Next
        tb.ResumeRedraw()       
       
        \'------------------------------------------------------------
        e.Form.Controls("But生成物料").performclick
    Else
        Exit Sub
    End If
Else
    MessageBox.Show("请输入产品或半成品代码后再导入")
End If