Tuesday, 29 March 2011

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")

No comments:

Post a comment