Quality is delighting customers
DTsheet:index or name of the sheet which u want to export to excel file.
I want to export Result Set into excel. All these method which you are telling are used to export datatable data into excel sheet not of result set.
You might want to try this
Function WriteResults(sTablePath,sNumber, intRowCount)
Datatable.importSheet sTablePath, "Sheet1","Sheet1"
Datatable("<column_name>","Sheet1") = sNumber
Save this code as a .vbs file and call the function where ever needed
I believe you are looking this:
Select File menu in HP Run Results Viewer
Select Export To file
Select Format (HTML / Doc / XLS) to export QTP Test Results.