Skipping Rows in Excel file

Experiences, small talk, and other automation gossip.
segfault
Posts: 2
Joined: Mon Jan 06, 2014 11:36 pm

Skipping Rows in Excel file

Post by segfault » 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.

MarkusT

Re: Skipping Rows in Excel file

Post by MarkusT » Wed Jan 08, 2014 3:04 pm

Hello segfault,

You could use the same Excel file for both Test Cases in Ranorex Studio.
Simply define the Data Range for TestNameA from 1-4 and for TestNameB from 5-8.
You would only need to bind your ExpectedData with a variable (e.g. tData) in your Recording module.

Another way would be to use separate Excel sheets for each Test Case.
Please let me know if you need more information.

Regards,
Markus (T)
Attachments
TestSuite.png
TestSuite.png (11.39 KiB) Viewed 1021 times