1: AddSheet 方法
DataTable.AddSheet(SheetName)
Dim Variable
Variable=DataTable.AddSheet ("MySheet").AddParameter("Time", "8:00")
2:DeleteSheet方法
DataTable.DeleteSheet SheetID
DataTable.DeleteSheet "MySheet"
3:Export方法
DataTable.Export ("C:\flights.xls")
4:ExportSheet方法
DataTable.ExportSheet(FileName, DTSheet)
DataTable.ExportSheet "C:\name.xls" ,1 '索引值从 1 开始
DataTable.ExportSheet "C:\name.xls" , " MySheet "
5:GetCurrentRow方法
DataTable.GetCurrentRow
row = DataTable.GetCurrentRow
Reporter.ReportEvent 1, "行号", row
6:GetRowCount方法
DataTable.GetRowCount
rowcount = DataTable.GetSheet("MySheet").GetRowCount
Reporter.ReportEvent 2, "数据工作表中有 " &rowcount, "行。"
7:GetSheet方法
DataTable.GetSheet(SheetID)
DTSheet 对象
MyParam=DataTable.GetSheet ("MySheet").AddParameter("Time", "8:00")
DataTable.GetSheet ("MySheet").AddParameter "Time", "8:00"
8:GetSheetCount方法
DataTable.GetSheetCount
sheetcount = DataTable.GetSheetCount
Reporter.ReportEvent 0, "工作表编号", "数据表中有 " & sheetcount & " 个工作表。"
9:Import方法
DataTable.Import(FileName)
DataTable.Import ("C:\flights.xls")
10:ImportSheet方法
DataTable.ImportSheet(FileName, SheetSource, SheetDest)
DataTable.ImportSheet "C:\name.xls" ,1 ," Action1"
DataTable.ImportSheet "C:\name.xls" ,1 ," Global"
Qtp中不要使用Global表,会出现死循环现象。
11:SetCurrentRow方法
DataTable.SetCurrentRow(RowNumber)