I have to import excel sheet into QTP . perform action taking data one by one and save the result value in a new column against the data and save the runtime data table on my machine in a excel.
Try with ExportSheet..
DataTable.ExportSheet "C:\name.xls" ,1
Certified HP consultant