Skipping Rows in Excel file
Posted: Mon Jan 06, 2014 11:49 pm
I am trying to automate a process to input some data in a web application using Excel Sheets. The excel sheet is of the format
|Test Name| Test Step | Expected Data|
| A | Step 1 | Data 1 |
| | Step 2 | Data 2 |
| | Step 3 | Data 3 |
| | Step 4 | Data 4 |
| | | |
| B | Step 1 | Data 1 |
| | Step 2 | Data 2 |
| | Step 3 | Data 3 |
| | Step 4 | Data 4 |
The Test Name is the Test Case Name I want to input in the application and Step1, Step2....and Data 1, Data 2....are the Steps for the particular test Step.
Now, I have 3 variables in the recording tName, tStep, tData which I bind to the Excel data connector. Question is, How do I loop over each individual Test Name and then for each test name loop over each Test Step? I want to be able to skip the rows in the Test Name column and only input the data if there is some value present in that column.
|Test Name| Test Step | Expected Data|
| A | Step 1 | Data 1 |
| | Step 2 | Data 2 |
| | Step 3 | Data 3 |
| | Step 4 | Data 4 |
| | | |
| B | Step 1 | Data 1 |
| | Step 2 | Data 2 |
| | Step 3 | Data 3 |
| | Step 4 | Data 4 |
The Test Name is the Test Case Name I want to input in the application and Step1, Step2....and Data 1, Data 2....are the Steps for the particular test Step.
Now, I have 3 variables in the recording tName, tStep, tData which I bind to the Excel data connector. Question is, How do I loop over each individual Test Name and then for each test name loop over each Test Step? I want to be able to skip the rows in the Test Name column and only input the data if there is some value present in that column.