QTP: How to import data from an excel sheet to qtp data tables

1:'Get  path of files

2:TestCases="D:ApplicationsTestAppAutomationAutomationFramework.xls"

3:TestSteps="D:ApplicationsTestAppAutomationAutomationFramework.xls"

4:TestData="D:ApplicationsTestAppAutomationInputData.xls"

5:'Import test case list

6:datatable.AddSheet "dTestCases"

7:datatable.ImportSheet TestCases,"TestCases","dTestCases"

11:'Import  testcase data12:datatable.AddSheet "dTestData"13:datatable.ImportSheet TestData,"TestData","dTestData"

Post Views: 813