Execute data-driven tests | Ranorex
Help CenterUser GuideRanorex Studio advanced

Run a data-driven test

Now that we’ve finished our data-driven test, we can run it. This works the same as for other tests.

In this chapter

    tipp icon

    Screencast

    The screencast “running a data driven test” walks you through the information found in this chapter.:

    Watch the screencast now

    Download the sample solution

    This is the completed sample solution with all the instructions of the previous chapters carried out and ready to run.

    Sample solution

    Theme: Run a data-driven test
    Time: 5 minutes

    Download sample file

    Install the sample solution:

    Unzip to any folder on your computer.
    Start Ranorex Studio and open the solution file RxDatabase.rxsln

    tipp icon

    Hint

    The sample solution is available for Ranorex versions 8.0 or higher. You must agree to the automatic solution upgrade for versions 8.2 and higher.

    Run the test

    Check if all variables are bound correctly.
    Click RUN.

    Executing a data-driven test

    Result

    Once the test has finished, the report appears. The rows of the data-driven test case are shown in the results.

    Data-driven test result

    Result details for a data-driven test

    When we take a more detailed look at the test case, we see that it was iterated once for each data row. So, in total, the test case was run 8 times.

    The details for each iteration also show the current variable values for this iteration.

    Detailed test result of data-driven testing

    Further reading

    Reporting is explained in detail in Ranorex Studio fundamentals > ⇢ Reporting.

    Microsoft Excel-free test execution on runtime machines

    If you want to deploy a data-driven test that uses Excel connectors via ⇢ XCOPY or a ⇢ Ranorex Agent, the target machine doesn’t need to have an Excel license installed. Simply install the Microsoft Access Database Engine Redistributable >=2013 on the target machine and you can run the test.

    You can also configure the behavior of the Excel-free execution implementation in the solution settings file.

    In the projects view, open the solution settings file.

    Locate the setting <Testing.Data.ExcelDataLoadingPreference>.

    Enter one of four options (all are entered in the image for illustration purposes):

    PreferExcel: Default. Uses Excel if available, else uses AceOleDb (the free database engine). Test fails if neither is available.

    PreferAceOleDb: Uses AceOleDb if available, else uses Excel. Test fails if neither is available.

    RequireExcel: Uses Excel only. Test fails if it isn’t available.

    RequireAceOleDb: Uses AceOleDb only. Test fails if it isn’t available.