I use xls.rb which works great with Excel. see https://github.com/bash0C7/XLS Its old, but allows range names to be used in the calls so as your data sets grow or add columns you're not updating code only the excel sheet. It delivers a nice hash array. where myExcel[1].fetch('Login') would return the value I want without regard to column or row index
| Login | Password | more | | xxxx | any | stuff | On Jun 7, 12:07 pm, He Bing Lin <peter...@gmail.com> wrote: > Thanks alot i will check this out. will post my result later > > > > > > > > On Friday, June 7, 2013 12:00:02 PM UTC-4, Al Snow wrote: > > > Try roo: > >http://3qilabs.com/2011/03/using-watir-and-roo-to-read-data-from-spre... > > > ------------------------------ > > Date: Fri, 7 Jun 2013 08:56:05 -0700 > > From: pete...@gmail.com <javascript:> > > To: watir-...@googlegroups.com <javascript:> > > Subject: [wtr-general] Open local excel file and assert data > > > Can watir open local excel sheet file? then compare the data in a cell to > > a table data on the web? If watir cannot do it, is any other automation > > tools possible such as selenium etc. Thank you very much > > -- > > -- > > Before posting, please readhttp://watir.com/support. In short: search > > before you ask, be nice. > > > watir-...@googlegroups.com <javascript:> > >http://groups.google.com/group/watir-general > > watir-genera...@googlegroups.com <javascript:> > > > --- > > 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-genera...@googlegroups.com <javascript:>. > > For more options, visithttps://groups.google.com/groups/opt_out. -- -- 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.