[Wtr-general] Using Data from CSV or XLS

[Cain, Mark]

I like faster cvs better http://rubyforge.org/projects/fastercsv/ 

 

$LOAD_PATH.unshift File.join(File.dirname(__FILE__), '..') if $0 ==
__FILE__

require 'setup'

require 'faster_csv'

 

class TC_Search < Test::Unit::TestCase

  

  def init()

    

      @PATH1 = File.join(File.dirname(__FILE__), "completedby.csv")

 

      puts "Reading in CompletedBy data..."

      $completedBy = []

      FasterCSV.foreach(@PATH1) do |row| 

        $completedBy.push row

      end

  end

...

 

    int = rand($completedBy.length)

    $ie.frame(:index, 4).text_field(:name,
"DateBy").set($completedBy[int][0])

    $ie.button("Submit").click

    int = nil

 

...

 

End

 

This script snippet loads an array from a csv file and then randomly
grabs a value from that array and loads it in a search field.

 

Hope this helps,

 

--Mark

 

________________________________

From: wtr-general-bounces at rubyforge.org
[mailto:wtr-general-bounces at rubyforge.org] On Behalf Of Chintakrindi
Meghanath 
Sent: Tuesday, April 11, 2006 10:52 AM
To: wtr-general at rubyforge.org
Subject: [Wtr-general] Using Data from CSV or XLS

 

Hi

We  are using watir for our web application.

We want to use Data Driven methodolgy using xls or CSV ie taking data
from the excel or csv file.

 

Thanks

Meghanath

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://rubyforge.org/pipermail/wtr-general/attachments/20060411/8f1f24eb/attachment.html