Data-Driven Testing
上一篇 /
下一篇 2009-03-03 19:59:53
xuYxBU0 51Testing软件测试网,o@:k/u!_ St
数据驱动方法的步骤:
第一步:从存储点上读入数据
51Testing软件测试网+Zk6`6R4p%m例子(VB): 51Testing软件测试网,S6\zd,s u+g|;[
8f4]0dy7mM? q7^0'从Excel表格读入数据
)u"C0J:v\ |U0sub readExcel
$Ig |o4P-y0 dim Driver
7x/Tk5D&j|Gu_d0 dim rid '行号
6Cl^Nk,X5I0 dim cid '列号51Testing软件测试网:j7aS%LfWDHGJ'^
rid = 0
[&Dnu(Rp6zV0 set Driver = DDT.ExcelDriver("D:\myfile.xls","sheet1",False)51Testing软件测试网6O8H5zJ6F
ShowMessage("Driver_Name:"&Driver.Name)51Testing软件测试网w@$p3wX
do while not Driver.EOF
0s'X+L j;r;q&V&k-T;s0 cid = 0
${;ky9tp7K0H8F,W_#H0 ShowMessage("row id :"&rid)
;{"h.q6\)g%p;h+U0 do while cid < Driver.ColumnCount 51Testing软件测试网El
If;S K4b7]
ShowMessage("column id:"&cid&" "&"Column_Name:"& _51Testing软件测试网X0V#QzqD1m*Qz
Driver.ColumnName(cid)&" "&"Value : "&Driver.Value(cid))51Testing软件测试网PL f S*D2c9L5{a%s
cid = cid + 1