How to work with Excel files using QTP?

  
Using the following code a given excel sheet can be opened

    Set suitExcelobj= CreateObject("Excel.Application")
    Set suitExcelWorkbook=suitExcelobj.Workbooks.Open("C:\Testdata.xls)
    Set suitExcelWorkSheet=suitExcelobj.WorkSheets("Scenario1")