Parameterization using Excel Application in QTP 9.2

We should have a clear understanding of How to import an external data sheet in to QTP and parametrize the script with Excel Application? Because there is a problem using the local data sheet because if we want to make any changes in the data or use a different set of data then for each time we need to open Quick Test Application, open the script and make the changes in the script local data sheet or the global data sheet and this is time consuming and also not the best practice.

Instead of opening the script every time the data is changed we can actually create a excel sheet and store it externally and then call it into the run time data sheet. This is easy to maintain and no confusion at all. You need to create the excel sheet with all the values and then use the excel library commands in the script to invoke the excel worksheet and then point the columns to the corresponding variables.

When you work with excel worksheet always keep in mind that the first row is set for the parameter names i.e the first row columns should have the variable names which we call in the script.

If you want the data to be imported to the global sheet then the data in the excel file should be stored in the Sheet 1 of the file. If you want the data to be imported to the Local sheet then the data in the excel file should be stored in Sheet 2 of the file. We will parametrize the variables with the excel application and directly pull in the data from the columns in the excel sheet.