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)