I was working on something to do similar a while back (with some help from MB I think)

 

I got an xls sheet test running against what I wanted but then work got in the way and I haven’t been back to it for a bit

 

I have tried posting what I have but not sure the attachments will come thru. The XL sheet Has to be in the same folder as the script, It runs against Virgin Atlantics public site so it should work for anyone (Sorry it is still full of all the rubbish I put in when I’m working) But hope it points you in the right direction.

 

If you come up with better cleaner etc post it back I’d love to see it.

 

It basically goes across then down rows and grabs

 

Type of object from 1

ID (?? Cant remember  what that is? The ID of the object perhaps?) from 2

Value we set it to from 3

Validate (??Again Cant remember  what that is? The ID of the next  object perhaps?) from 4

And finally what we expect to see from row 5.

 

So it goes B1 – 5 C 1 – 5 Etc

 

It is set up so B fails C, D and E Pass

 

(have just re read it and its pretty all over the place but I’m sure you’ll get the idea)

 

Malcolm Beaton

M +44 (0) 777 071 3121 


From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anil Kumar Das
Sent: 11 April 2006 21:23
To: [email protected]
Subject: [Wtr-general] data driven testing using WTR

 

I am trying to implement data driven testing using xls sheet & watir.
 

For example:
1. I have an xls sheet(c:/info.xls) with three columns called name,ssn, telephone/ 10-10 records in each column
2. My screen has three fields and submit button
name
ssn
telephone

I want to get data from xls sheet, enter in screen & submit records one by one.
 

Any workaround?? -- how to do this using watir or ruby
 


_____________________________________________________________________
This e-mail has been scanned for viruses by MessageLabs. The information contained in this message is confidential and is intended for the addressee only. If you have received this message in error, please notify Conchango plc as soon as possible. The unauthorised use, disclosure, copying or alteration of this message is prohibited and may be unlawful. The internet cannot guarantee the integrity of this message and therefore Conchango plc will not be liable for the message if modified.

Reg. Heritage House, Church Road, Egham, Surrey, TW20 9QD T 44 (0) 1784 222 222 F 44 (0) 1784 222 200 E [EMAIL PROTECTED] No. 2598884

Attachment: TempTry.rb
Description: TempTry.rb

Attachment: FieldControlDem.xls
Description: FieldControlDem.xls

_______________________________________________
Wtr-general mailing list
[email protected]
http://rubyforge.org/mailman/listinfo/wtr-general

Reply via email to