Importing data sheet

[Santu]

hi all,

i am new to qtp. so can you please help me that how to import value to excel sheet

[supputuri]

you can check for ExportSheet or Export datatable methods in help.

Code:

DataTable.Export FileName
DataTable.Export ("C:\flights.xls")

Code:

DataTable.ExportSheet FileName, vtSrcSheet, [DstSheetName]
DataTable.ExportSheet "C:\name.xls" ,1

[ADITI1992]

Also if you are creating excel object then u can code like this..
sheet.cells(i,j).value=4,5,etc.. to set values in cells
workbook.save
xl.quit ' to quit excel application
set xl = nothing ' to release memory