Reading data from Excel
Data-driven testing is a useful feature for the following scenarios:
- When business users would like to have ownership over the test data in your automated tests
- When you have multiple data permutations and you would like to loop through data sets
- When you would like to perform multiple calculations on your data and use Excel as a method of deriving the fields
Provar has Read and Write test steps to read data from an Excel sheet or a database and write data to an Excel spreadsheet.
This page describes how to configure Provar to test using data from Excel. You can also refer to Write Data Into Excel for more information.
In order to read from an Excel sheet, first get your Excel file ready on your local machine.
Next, read the Excel file into your test case using Add Parameter Value Source. You can do this from any test step, but you will often find it useful to do it on your For Each test step, if you are using one. (For Each is often used within Data-Driven Testing to iterate the same action through each data row.)
To read the Excel data into your Test Case, click the Add Parameter Value Source icon () in the top-right of the Test Step.
This will add the following new section to your Test Step:
You can populate this as follows:
Step 1: If you are on a Windows machine, navigate to your Excel file and highlight the range of cells you want to read into Provar. Then select CTRL+C to copy. Navigate to Provar and select the Populate From File icon (). This will populate the File, Worksheet and the Values Range fields.
Step 2: If you are using a Mac, you will need to populate File, Worksheet and Values Range manually. Use File Chooser () icon to help you set the File path.
Step 3: In the Name field, select the orientation of the headers.
Step 4: In the Where field, specify any filter you want to be applied to the data being imported.
Step 5: In Variable, specify your preferred object name for the results (the default is ExcelData).
Step 6: Then parameterize the Test Case.
Here is an example Excel spreadsheet with the corresponding Parameter Value Source parameters populated below.
Add to test case
Once you have read the data from the Excel sheet, you need to use it in your test case. This is typically done using a For Each or While test step, to loop through multiple rows and a create a test step to create the data.
Step 1: Use Content Assist to access the fields in the SourceData object.
Step 2: Specify the list Name (e.g. SourceData) and the Value Name in the For Each test step. (The Value Name is the name for the current iteration.)
Step 3: Use the full stop to access the column headings.
- General information
- Licensing Provar
- Provar trial guide and extensions
- Using Provar
- API testing
- Behavior-driven development
- Creating and importing projects
- Creating test cases
- Debugging tests
- Defining a namespace prefix on a connection
- Defining proxy settings
- Environment management
- Exporting test cases into a PDF
- Exporting test projects
- Managing test steps
- Namespace org testing
- Provar desktop
- Provar Test Builder
- Refresh and Recompile
- Reload Org Cache
- Running tests
- Searching Provar with find usages
- Secrets management and encryption
- Setup and teardown test cases
- Tags and Service Level Agreements (SLAs)
- Test cycles
- Test plans
- Testing browser options
- Tooltip testing
- Using the Test Palette
- Test Palette introduction
- Control test steps
- List compare
- Read test step
- String test steps
- UI Test Steps
- Using custom APIs
- Callable tests
- Data-driven testing
- Page objects
- Applications testing
- Database testing
- Document testing
- Email testing
- Mobile testing
- OrchestraCMS Testing
- Salesforce CPQ testing
- ServiceMax testing
- Skuid testing
- Vlocity testing
- Webservices testing
- Introduction to test scheduling
- Apache Ant
- Configuration for sending emails via the Provar Command Line Interface (CLI)
- Continuous integration
- Azure DevOps
- Running a Provar CI task in Azure DevOps
- Configuring the Provar secrets password in Microsoft Azure Pipelines
- Parallel execution in Microsoft Azure Pipelines using multiple build.xml files
- Parallel execution in Microsoft Azure Pipelines using targets
- Parallel execution in Microsoft Azure Pipelines using Test Plans
- Bitbucket Pipelines
- Circle CI
- GitLab CI
- Travis CI
- Parallel Execution
- Running Provar on Linux
- Salesforce DX
- Team foundation server
- Version control
- Zephyr Cloud and Server (Beta)
- Salesforce testing
- Adding a Salesforce connection
- Assert Page Error Messages on Add/Edit Product
- Internationalization support
- List and table testing
- Salesforce Release Updates
- Salesforce Lightning Testing
- Salesforce Lightning Web Component (LWC) locator support
- Service Cloud console testing
- Visualforce Testing
- Testing best practices
- Configurations and permissions
- Error messages
- Licensing, installation and firewalls
- Test Builder and test cases
- Release notes