HCL OneTest Data support to generate test data for an Excel file

When you use Microsoft Excel as a database in your application testing environment and you want to use the structure of an Excel file to generate test data, then you can generate the test data for the selected Excel file by using HCL® OneTest Data.

When you want to generate the test data for the Excel file, then you must import the file into your HCL® OneTest Data project. After importing the file, you must establish a connection between Excel and HCL® OneTest Data. The established connection helps to transfer the data and interpret the data of the imported Excel file into your HCL® OneTest Data project. The interpreted information then helps HCL® OneTest Data to generate a schema. You can then use the generated schema to generate the test data in HCL® OneTest Data.

Prerequisites

The following prerequisites must be met to enable HCL® OneTest Data to write the generated test data:
  • You must have access to HCL OneTest Server.
  • You must have an Excel file on your computer.

Task flow

You must perform the following tasks in sequence to enable HCL® OneTest Data to generate the test data for the Excel file. The table also provides you the links to the information about the tasks.

Task More Information
Import an Excel file.

Importing an Excel file.

Establish a connection between Excel and HCL® OneTest Data.

Establishing a connection between Excel and HCL OneTest Data.

Generate a schema based on an Excel file.

Generating a schema based on an Excel file.

Generate test data by using the generated schema.

Generating test data by using the generated schema.