在FOX命令窗口中执行代码1和代码2,怎么感觉用XLS.BOOK打开一个EXCEL文件比用MSEXCEL打开要快得多呢?
代码1:
Dim st As Date = Date.Now
Dim ft As String = "D:\temp\1.xls"
Dim eapp As new msexcel.application
Dim wb As msexcel.workbook=eapp.workbooks.open(ft)
Dim ws As msexcel.worksheet=wb.worksheets(1)
Output.Show("耗时: " & (Date.Now - st).TotalSeconds & "秒") '计算
代码2:
Dim st As Date = Date.Now
Dim ft As String = "D:\temp\1.xls"
Dim Book As New XLS.Book(ft)
Dim Sheet As XLS.Sheet = Book.Sheets(0)
Output.Show("耗时: " & (Date.Now - st).TotalSeconds & "秒") '计算