From: Madu Nar <bharadwaj.n@...>
Date: 2006-09-12T02:26:53+09:00
Subject: Re: Read from XLS and substitute values in Ruby (Watir)

Hello Paul,
   Thank you so much for the Info...
   I tried and it did work. But, how do I pass each of those split 
tokens as separate parameters for the text fields.

Ex:      ie.text_field(:name, 
"SearchFormHandler.searchTerms").set("Brian Kantz")
         ie.select_list(:name, 
"SearchFormHandler.state").select("California")

So the values Brian Kantz, California should be automatically 
substituted from the file... Your help is greatly appreciated...

Thanks,
Madu

Paul Lutus wrote:

> Madu Nar wrote:
> 
>> I need to pass each row of records into a text_fields for username and
>> password and click on go...
>> 
>> I need to do this till the end of the file... could somebody tell me as
>> to how I parameterize the values for the text fields so that it
>> automatically picks up the records for each row...
> 
> In your example above, one of the field names is "User Name", with a 
> space.
> Yet the field separator for the data records below it appears to uses 
> one
> or more spaces as delimiters. On the other hand, it might be tabs, hard 
> to
> tell from your post.
> 
> Let's assume that tabs are used instead of spaces between the fields. If
> that is true, then (untested):
> 
> File.read("filename").each do |record|
>    record.split("\t").each do |field|
>       # your turn
>    end
> end


-- 
Posted via http://www.ruby-forum.com/.