Question: how to retrieve data from excel sheet in qtp?
Answer: first you need to change the excel to 2003 format as QTP does not support 2007 format. then you can use Datatable. importsheet or datatable. import statements to import the sheet to your test.