Retriving data from Excel Sheet to qtp

2011-11-14T22:14:00.000-08:00

I want to be more specific about my question

I have an Excel file called: "AgentLogin.xls" in the folder "D:\Sample programs"
In this file I have a sheet called "Login". In the sheet I have 2 columns which looks as follows:
Column A: Agent Name
Column B: Password

In my application, I have 2 WinEdit fields also called Agent Name,Password

So how should the code look like if I want to retrieve the data from the 2 columns in Excel and populate the WinEdit's in my application ?

truetesting

Retriving data from Excel Sheet to qtp