Data Table Relating Code

1) How to import excel file from local machine to Datatable?

A) Datatable.Import "C:\import.xls"

2) How to Export datatable to local machine?

A) Datatable.Export "C:\Export.xls"

3) How to import specific sheet from local machine into datatable?

A) Datatable.importsheet file path,source sheet name,destination sheet name

4) How to export specific sheet from datatable into local machine?

A) Datatable.Exportsheet file path,Datatable sheet name / Index

5) How to get row count of a runtime data table sheet?

A)
Dim RowCount
For global sheet
RowCount=DataTable.GetRowCount

For specific sheet or Local sheet
RowCount=DataTable.GetSheet("SheetName").GetRowCount

6) How to add a sheet to the runtime data table?
A) Datatable.Addsheet(“SheetName”)

7) How to add a column to the runtime data table?
A) Datatable.GetSheet("Sheetname").AddParameter "ParameterName",""

8) How to get data from runtime datatable?
A) Datatable.value(“ColumnName”,”SheetName”)

We can get data in different way also
From global sheet:
Datatable.Value(“ColumnName”,dtGlobalSheet)
From Local Sheet:
Datatable.Value("ColumnName",dtLocalSheet)

9) How to import excel file from Quality center (9.2) to QTP (9.2) data table?

A)
We can import with data table import command, but file path we have to give in specified format only. See the below code.

Code:- DataTable.ImportSheet "[QC-ATTACH];;Subject\DomainName\Project Name\Automation\ScriptName;;\Excelfilename.xls","Source Sheet name","Destination sheet name(datat tale sheet name)"