Can single test case be binded with multiple excel sheets?

Ask general questions here.
navneetd
Posts: 2
Joined: Mon Mar 13, 2023 9:45 am

Can single test case be binded with multiple excel sheets?

Post by navneetd » Mon Mar 13, 2023 2:46 pm

Hello, I would like to bind data from a few excel sheets in single testcase. All the sheets are in the same excel workbook. How can I do this?

Currently I'm using excel data connector for one test case which is taking only 1st Sheet. Ideally, I want excel data connector to iterate through all sheets of the excel file in the same test case.

The main intention to be repeat same TestCase execution with multiple sheets of excel file.

IvanF
Posts: 151
Joined: Thu Aug 11, 2022 8:55 pm

Re: Can single test case be binded with multiple excel sheets?

Post by IvanF » Mon Mar 13, 2023 2:56 pm

Hi, for data-driven testing, you would need all data in the same sheet based on the format outlined here - https://www.ranorex.com/help/latest/ran ... anagement/

You could probably create multiple excel data connectors (1 per sheet) and the same number of duplicate test cases, then connect them in a 1-to-1 fashion, but that would create excessive maintenance on the test case side.

Not sure if there is a better workaround from the user code side, with a custom iterator for the same test case. But at that point, merging the sheets may be easier.

navneetd
Posts: 2
Joined: Mon Mar 13, 2023 9:45 am

Re: Can single test case be binded with multiple excel sheets?

Post by navneetd » Tue Mar 14, 2023 6:31 am

Instead of creating multiple excel data connectors (1 per sheet) and the same number of duplicate test cases, Is there any alternative way for reusing the same testcase with multiple excel dataconnectors where the same testcase must iterate through all excel dataconnectors(excel files) and executes by itself??

IvanF
Posts: 151
Joined: Thu Aug 11, 2022 8:55 pm

Re: Can single test case be binded with multiple excel sheets?

Post by IvanF » Tue Mar 14, 2023 6:16 pm

Not through the UI right now; the same test case will only iterate through the rows of one connector. Feel free to submit the feature request at https://www.ranorex.com/support-query/

and/or look into the possible user code solutions.