10-19-2012, 04:03 PM
Hi,
I want to control localsheet iteration based upon globalsheet.
e.g.-I have 3 worksheets in an excel file-
1)globalsheet
2)local1
3)local2
the 1st row in all the 3 sheets contain testcase ids.
I want to run the script so that it will pick the 1st value from the globalsheet ,will move to the next worksheet,pick the corresponding values from all the columns for which the row no is 1 and then move to the next worksheet and do the same.
The worksheet is individual for each action which is based on individual page according to the application.
Please take a look into the attached excel file.(rename the file to ".xlsx" since i am not allowed to upload an excel file
New Microsoft Office Excel Worksheet (2).txt (Size: 13.5 KB / Downloads: 132) )
I want to control localsheet iteration based upon globalsheet.
e.g.-I have 3 worksheets in an excel file-
1)globalsheet
2)local1
3)local2
the 1st row in all the 3 sheets contain testcase ids.
I want to run the script so that it will pick the 1st value from the globalsheet ,will move to the next worksheet,pick the corresponding values from all the columns for which the row no is 1 and then move to the next worksheet and do the same.
The worksheet is individual for each action which is based on individual page according to the application.
Please take a look into the attached excel file.(rename the file to ".xlsx" since i am not allowed to upload an excel file
New Microsoft Office Excel Worksheet (2).txt (Size: 13.5 KB / Downloads: 132) )