QTP中對datatable的一些操作指令
1.得到datatable總行數的指令: GetRowCount
R `o(W6iv(mV0 文法:Datatable.GetRowCount51Testing軟體測試網dzd ooI;n4W
例: DataTable.GetSheet("MySheet").GetRowCount
2.得到datatable運作時的動态列數: GetParameterCount
'k0F,Z0[3Utp A:K0 文法:DTSheet.GetParameterCount51Testing軟體測試網U.kS6}*KZ*XN9}
例: paramcount = DataTable.GetSheet("MySheet").GetParameterCount
3.設定目前active的行數,第一行為1: SetCurrentRow
e7Qjd5` eT0 文法:DataTable.SetCurrentRow(RowNumber)
Sm,|'G2P {i1tH0Z"/2eG1s0 例: DataTable.SetCurrentRow(tb_i+1) '注:此指令可在循環運作中不斷指向下一行資料
4.查詢、設定datatable的數值:Value51Testing軟體測試網 G^u9xka^ S
文法:To find the value:
/jV5cl-v'z0 DataTable.Value(ParameterID [, SheetID])
P[%`&D}{@q1F0 or : DataTable(ParameterID [, SheetID])
9wF.~ rW7S)U4{0 To set the value: 51Testing軟體測試網/n zQkH
DataTable.Value(ParameterID [, SheetID])=NewValue
R)BO |$Qw!d,p0 or : DataTable(ParameterID [, SheetID]) =NewValue 51Testing軟體測試網}}R,{o3p/i q
例: DataTable.Value ("Destination", "ActionA")="New York"51Testing軟體測試網W~b I/
DataTable.Value (2,3)="New York"51Testing軟體測試網z}D y&bz
DataTable("Destination", dtlocalSheet)="New York"51Testing軟體測試網~r np$_mxT9Q
Call_date= DataTable.Value("Date","add Conference Call") '為Call_date指派
5.取datatable特定行的資料:
$v(^!x[/f)T1F0DataTable.GetSheet("Action1").GetParameter("test/").ValueByRow(4)