Micro Focus QTP (UFT) Forums
How to export data from QTP to Excel 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: How to export data from QTP to Excel sheet? (/Thread-How-to-export-data-from-QTP-to-Excel-sheet)



How to export data from QTP to Excel sheet? - mansis - 09-26-2012

Hi,

I want to export data from QTP to excel sheet and then I need to write the data in Excel sheet.

Following is the script which I prepared.. But it is giving error. Please let me know that what is wrong in below script.

------------------
Code:
display= Browser("Food product").Page("Entry").Frame("Frame").Link("Username").GetROProperty("innertext")

msgbox display

DataTable.Export("D:\Emp")

'To post the value of var in excel sheet

DataTable.Value("Detail",Sheet) = display


----------
Thanks.


RE: How to export data from QTP to Excel sheet? - Ankesh - 09-26-2012

what is the error that you are getting?