HOW TO GET DATA FROM EXCEL INTO QTP WITHOUT IMPORTING THE EXCEL IN QTP

Steps:

Assign the path of excelfile to variable

Assign  the 1 to row,column variables

Declare the function for excel by passing the path,sheet,row,column

Create an object of excel

Open the path of excel file by using workbooks object

Assign the sheet data to variable

Closing the excel object

Relese the excel object

Close the function

Using msgbox  for viewing  the variables

Ans:

For this code make sure that you have excel file Book1.xls under c:\ and write some dummy values in its first few cells.

Write the whole above code in a new test in QTP and run it.