Hi Venky! The 'PickLists' tab in the spreadsheet is meant to hold data for selection in the other tabs. This is to make it simpler to enter values that are commonly used. For example, the cell that holds the URL value in the 'Setup' tab functions as a dropdown with the options from the 'PickLists' tab.
The first table in the 'Setup' tab (A1:B6) is for data used for the test run - the URL, usernames, passwords, etc. The second table in the 'Setup' tab (A12:B15) specifies which tests to run and the 'Yes/No' value in those cells are used the Test::Unit framework code. If you're specifying first a project to run and then the methods in that project, you'll need to add some more code to break it out at the method level. Hope this helps! -Tiffany On Dec 17, 5:56 am, venkat <[email protected]> wrote: > please help me if anybody tried with the watir wiki's > DataDrivenTestHarnessExample - "Picklist" speadsheet data fetching from > TestData.xls > > I have the data in Testdata.xls as the following: > *Project* *Run* Project1 Yes > > *Module* *Run* Module1 Yes Module2 Yes Module3 Yes Module4 No > > What could be the watir code, any clues? if wants to run tests where the Run > = Yes irrespective of Project name or ModuleName. My script should pick the > Cell data from Project or Module columns to RUN tests if it is Yes. > > I tried like this...but could not succeed. > -------------------------------------- > begin > xlFile = XLS.new("Dir.pwd + '../TestData.xls") > $Runtests = xlFile.getRowRecords("A1:B5", "Sheet1") > ensure > xlFile.close > end > $runTests.each do |record| > ----------------------------------------- > please help...any thoughts.. > > thanks, > -venky -- You received this message because you are subscribed to the Google Groups "Watir General" group. To post to this group, send email to [email protected] Before posting, please read the following guidelines: http://wiki.openqa.org/display/WTR/Support To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/watir-general
