1、放在哪里都可以;
2、可以
Dim dlg As New OpenFileDialog
dlg.MultiSelect = True
If dlg.ShowDialog = DialogResult.OK Then
For Each fl As String In dlg.FileNames
Dim book As new XLS.Book(fl)
For Each sheet As XLS.Sheet In book.Sheets
Dim ip As New Importer
ip.SourcePath = fl
ip.Format = "excel"
ip.SourceTableName = sheet.Name & "$"
Dim fn As String = FileSys.GetName(fl)
ip.NewTableName = fn.SubString(0, fn.IndexOf("."))
ip.Import()
Next
Next
End If
3、不能沿用excel的格式;
4、DataTable