The method for transferring data from Excel to QTP is as follows:
- Open your Excel file containing the data you want to use in QTP.
- Select the data you want to transfer and copy it to the clipboard.
- Open QTP and navigate to the Test Data pane.
- Click on the Add DataTable button and select the Excel file you want to use.
- In the DataTable pane, click on the first cell under the column where you want to paste the data.
- Paste the data you copied from Excel into the cell.
- Repeat steps 5-6 for each row of data you want to transfer.
- Save the DataTable and use it in your QTP script to access the data.
Alternatively, you can use the Data Driver Wizard in QTP to create a connection to your Excel file and automatically transfer the data into your test script.