Yes it is possible using rubyxl gem. A complete example with cucumber scenario is here - http://www.seleniumframework.com/test-data/test-data-with-excel/
Otherwise just read section "Table identification" under rubyxl documentation - http://www.rubydoc.info/gems/rubyXL/3.3.3 cheers, www.seleniumframework.com On Monday, February 2, 2015 at 7:20:33 AM UTC-5, Mohan MK wrote: > > Hi All, > > I am trying to make my script datadriven, but would like to reference the > data from data sheet through *column names*. > This is what i had used in QTP > DataElementValue = DataTable.GetSheet(DataSheetName). > *GetParameter(DataFileColumnName).ValueByRow(LoopDataFileRow(i))* > > Is it possible ? i am using win32ole / selenium-webdriver (RSpec) / > TestWise > > Test_Case = @wrksheet.cells(@rows,"A") ['text'] works fine but > *i want to reference it with column header (@rows,'TestCase') ['tect']. > below is * > > A B C > *TestCase UserId Password* > valid bob test > invalid bob badpass > > Thanks in Advance > M.K.Mohan > -- -- Before posting, please read http://watir.com/support. In short: search before you ask, be nice. [email protected] http://groups.google.com/group/watir-general [email protected] --- 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 [email protected]. For more options, visit https://groups.google.com/d/optout.
