Hi!
Have you verified that you're getting data into myData? I think you
need to specify a cell range and worksheet for the data:
myData = xlFile.getRowRecords('A1:Z50', 'Example')
where 'Example' is the name of your worksheet.
Hope this helps!
-Tiffany
On Mar 10, 5:47 am, rrash586 <rrash...@gmail.com> wrote:
> Hello all actually in the below program i m trying to Retrieve data
> from one excel sheet and place that data on text field of google page
> and after click on search button will navigate to search result page
> Now i want to take this "url"(ie.url) of webpage and write it on
> other EXCEL sheet .But I m unable to add it using Xls method
> "write2DArray()"
>
> How to add single element in excel sheet using "Xls"(Excel Interface
> Class) class
>
> can anyone suggest me how to do it using "Xls"
> Thanks in advance
>
> require 'Xls'
> require 'watir'
>
> xlFile = XLS.new("D:\\test_XLS_data.xls") #grab the data file in the
> same dirrectory
> myData = xlFile.getRowRecords('Google Search Data','Example') #pull
> data records from excel
> xlFile.close
>
> $j=0
> $array =Array.new
> myData.each do |record|
> ie = Watir::IE.start('google.com')
> ie.text_field(:name,'q').set(record['SearchString'])
> ie.button(:name,'btnG').click
> result =ie.url
> $array[$j] =result
> $j=$j+1
> ie.close
> end
>
> xlFile = XLS.new("D:\\result_xls.xls")
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Watir General" group.
To post to this group, send email to watir-general@googlegroups.com
Before posting, please read the following guidelines:
http://wiki.openqa.org/display/WTR/Support
To unsubscribe from this group, send email to
watir-general-unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/watir-general
-~----------~----~----~----~------~----~------~--~---
