How to get current sheet from Datatable in QTP

Example

Below code will get the reference of given sheet in QTP

Set curSheet = DataTable.GetSheet("mysheet")

here you can pass numerical index of the sheet as well.

Once you get the reference of the sheet, you can access its methods and properties in QTP

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