Importing data sheet - Printable Version

Importing data sheet - Printable Version

+- Micro Focus QTP (UFT) Forums (https://www.learnqtp.com/forums)
+-- Forum: Micro Focus UFT (earlier known as QTP) (https://www.learnqtp.com/forums/Forum-Micro-Focus-UFT-earlier-known-as-QTP)
+--- Forum: UFT / QTP Beginners (https://www.learnqtp.com/forums/Forum-UFT-QTP-Beginners)
+--- Thread: Importing data sheet (/Thread-Importing-data-sheet--8610)

Importing data sheet - Santu - 08-17-2015

hi all,

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

RE: Importing data sheet - supputuri - 08-17-2015

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

RE: Importing data sheet - ADITI1992 - 08-20-2015

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