你代码写到那里?试试这样写
SystemReady = False
For Each file As String In filesys .GetFiles("c:\Data")
If file.EndsWith(".xls") OrElse file.EndsWith(".xlsx") Then
Dim Book As New XLS.Book(file)
Dim Sheet As XLS.Sheet = Book.Sheets(0)
Dim dr As DataRow = DataTables("报价汇总表").AddNew
dr("规格型号") = sheet(0,1).Text
dr("报价") = sheet(5,2).text
dr("美元每米") = sheet(6,3).text
dr("利润点") = sheet(7,3).text
End If
Next
SystemReady = True