Not sure why my original reply to this was deleted, but the problem with
roo here is that you're using open and not new. A quick look at the roo
documentation would clear up your issues.
On Monday, August 5, 2013 10:42:30 AM UTC-4, Nikhil Nerkar wrote:
>
> I want to login to gmail using userid & password from the excel stored on
> my machine.
> I am getting the error :
>
> C:/Documents and
> Settings/XXXX/Desktop/Watir/Project/TestProject/S10.rb:5:in `<main>':
> private method `open' called for Roo::Excelx:Class (NoMethodError)
>
> *Please advice....*
>
>
> require 'watir'
> require 'rubygems'
> require 'roo'
>
> xl = Roo::Excelx.open("C:\Documents and
> Settings\XXXX\Desktop\Watir\Project\TestProject\TestExcel.xlsx")
> xl.default_sheet = xl.sheets[0]
> c1=x1.cell(1,2)
> c2=x1.cell(2,2)
>
> B=Watir::Browser.new
> url="http://www.gmail.com";
> B.goto(url)
>
> B.text_field(:id,'Email').set c1
> B.text_field(:id,'Passwd').set 'abc'
> B.button(:value,'Sign in').click
>
>
--
--
Before posting, please read http://watir.com/support. In short: search before
you ask, be nice.
watir-general@googlegroups.com
http://groups.google.com/group/watir-general
watir-general+unsubscr...@googlegroups.com
---
You received this message because you are subscribed to the Google Groups
"Watir General" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to watir-general+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
