Datatable.Export("C:\Results\Actuals.xls")

Hi,

DataTable.Export("file path")

DataTable.ExportSheet("filepath","DTsheet")

DTsheet:index or name of the sheet which u want to export 
to excel file.

Ex:
Datatable.Exportsheet("c:\name.xls","name")

Datatable.exportsheet("c:\name.xls",1)

hai deep can you plz write comments for the script like
what is this name an 1 like these

I THINK IT IS NOT CLEAR . WE HAVE PASS THE RESULT DIRECTLY
INTO THE XL SHEET. SUPPOSE IF LOGIN PAGE IS VALID THAT IS
USERID AND PASSWORD AND LOGINBUTTON IS WORKING THEN THESE
TEST CASES SHOULD BE DISPLAYED IN XLFILE
 IF POSSIBLE I WILL TRY THIS CODE


CORRECT ME IF IAM WRONG

Hi Deeps all the above answers are absolutely wrong. Can 
any one please answer properly. We are not going to export 
our sheet. That is DataTable object every body knows it. 
But i want QTP results to export in .xls format. Awaitnig 
ur reply soon.

It is not possible to Export the Results Directely into 
Excel File,but it is possible to Export the Results into 
Runtime Datatable.

EX:
datatable.AddSheet "venu"
datatable.DeleteSheet "Global"
datatable.DeleteSheet "Action1"
datatable.ImportSheet "C:\Documents and 
Settings\Administrator\Desktop\Mallik.xls",1,"venu"
For i=1 to 9
	datatable.SetCurrentRow(i)
systemutil.Run "C:\Program Files\Mercury 
Interactive\QuickTest 
Professional\samples\flight\app\flight4a.exe"
Dialog("Login").WinEdit("Agent Name:").Set datatable
("A","venu")
Dialog("Login").WinEdit("Password:").Set datatable
("B","venu")
Dialog("Login").WinButton("OK").Click
Window("Flight Reservation").WinMenu
("Menu").Select "File;Open Order..."
Window("Flight Reservation").Dialog("Open 
Order").WinCheckBox("Order No.").Set "ON"
Window("Flight Reservation").Dialog("Open Order").WinEdit
("Edit_2").Set datatable("C","venu")
Window("Flight Reservation").Dialog("Open Order").WinButton
("OK").Click
x = Window("Flight Reservation").WinEdit
("Name:").GetVisibleText()
Datatable("D","venu")=x
Window("Flight Reservation").Close
Next

Results:x values will be Printed into Runtime Datatatable 
in D column

I hope this answer will suit your query:

After you execute QTP tests the result will be stored in 
report.xml file under current test directory.
Open blank excel-->Data-->Import External Data-->Import Data

you will get select Datasource Dialog box  then browse your 
test report.xml and click ok.