How to read excel file in QTP

Example - Below code will read Excel file in QTP.
Please note that below code works on .xlsx Excel file as well as .xls excel file.

                                             

filepath = "C:\Bugs\Report.xlsx"
Set objExcel = CreateObject("Excel.Application")
objExcel.Visible = True
Set Wb = objExcel.Workbooks.Open(filepath)
print Wb.worksheets(1).Cells(1,1).Value ' read value from Excel file from sheet1 at cell A1.

This is how we can read excel file in QTP. 

You can have a look at core QTP (UFT) concepts on Master Page.