Dim Book As New XLS.Book(表的路径)
Dim Sheet As XLS.Sheet = Book.Sheets(0) '引用工作簿的第一个工作表
t.StopRedraw
Dim nms() As String = { "Code","Title","Unit","A","P" }
For n As Integer = 1 To Sheet.Rows.Count -1
Dim r As Row = t.AddNew()
For m As Integer = 0 To nms.Length - 1
If Sheet(n,m).Value IsNot Nothing
r(nms(m)) = Sheet(n,m).Value
End If
Next
Next