This isn't a watir question, but the problem is that you don't want to use open, you want to use new. See the documentation here: https://github.com/hmcgowan/roo. Also, don't try to automate against gmail. If you need to check mail there, use the gmail gem.
See this thread for a discussion on that matter : https://groups.google.com/forum/#!searchin/selenium-users/gmail/selenium-users/8jR6Fw5ndxU/GbKzuBNYOGAJ 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.