Exporting Test Data for Test Automation

Test Modeller can export test data to Excel Spreadsheets, both separate or flat, and to VIP Outputs and Templates.

To export the Test Data, click “Tests” to bring up the Test Case sidebar, and click the Test Data icon.

Data exported to Excel will contain the defined Variables, as well as any static Values and resolvable data functions. Including resolvable data functions in test data means that data driven test automation using VIP is dynamic, rather than static; the functions will be resolved each time a test is executed, ensuring that test data that reflects the latest system under test is used to drive testing.

Note: The VIP data generation functions require the Excel Data Generation Add-In when used in Excel. Please review the Prerequisites and Installation article for the Excel Add-In for instructions on setting the Excel Add-In up.