How to import excel sheet to datatable in qtp

When we design a test automation framework in qtp, we usually store the test data inside excel sheets.
Sometimes we need to load the test data in datatable to execute the test cases.

We can either import all excel sheets from excel workbook or we can import particular excel sheet from the the workbook to the datatable

'to import all sheets from excel file, use below  line of code
datatable.Import "c:\abc.xls"


'to import  single sheet from excel file, use below  line of code
'here we are importing the sheet global from abc.xls into testdata sheet in datatable in QTP.
datatable.AddSheet "testdata"
datatable.ImportSheet "c:\abc.xls","Global","testdata"


You may find below links very useful if you want to know more about data tables in QTP.

1. How to export datatable sheets to excel
2. How to import excel-sheet to datatable
3. How to read value from cell in datatable in QTP
4. Explain setcurrentrow method in qtp
5. Datatable object in qtp
6. How to export datatable to excel in qtp
7. How to get current sheet from datatable
8. How to check if parameter exists in sheet in datatable in qtp
9. Explain dtsheet object in qtp
10. What are the utility objects in qtp

Please give your inputs, suggestions, feedback to Us about above QTP topic. We value your thoughts.