DTSheet Object In QTP

DTSheet is a sheet in the run-time Data Table in QTP. You can get reference to this object by using below statements.

DataTable.AddSheet
DataTable.GetSheet
DataTable.GlobalSheet
DataTable.LocalSheet

DTSheet supports below methods :-

AddParameter Method - Add new column to current sheet
DeleteParameter Method - delete an existing column from the active sheet
GetCurrentRow Method - get row number of active row from current sheet
GetParameter Method - gets the name of column given it's index
GetParameterCount Method - gets total number of columns in current sheet in datatable
GetRowCount Method - gets total number of rows from sheet
SetCurrentRow Method - Activate given row
SetNextRow Method - Move to next row
SetPrevRow Method - Move to previous row

Associated Properties

Name Property - get the name of current sheet.

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