老师,请问我要循环打开的excel表中的多张sheet,红色部分的代码可以这样写??为什么我这样写,总会循环多出一张奇怪的表呢??
Dim dlg As new OpenFileDialog
dlg.Filter = "Excel文件|*.xls;*.xlsx"
dlg.MultiSelect = True '允许选择多个文件
If dlg.ShowDialog = DialogResult.OK Then
For Each file As String In dlg.filenames
Dim dt As DataTable = DataTables("临时表")
Dim dt1 As DataTable = DataTables("销售订单管理")
Dim book As new XLS.Book(file)
For j As Integer = 0 To book.sheets.count - 1