In UFT, how to write data to excel file?

1.	In UFT, how to write data to excel file?
Answer» The correct syntax to write data to excel file in UFT is − filepath = “C:\Bugs\Reports.xlsx”Set objExcel = CreateObject(“Excel.Application”)objExcel.Visible = TrueSet Wb= objExcel.Workbooks.Open (filepath)Wb.worksheets(1).Cells(1,1).Value = “TutorialPoints” read value from Excel file

Answer»

The correct syntax to write data to excel file in UFT is −

filepath = “C:\Bugs\Reports.xlsx”Set objExcel = CreateObject(“Excel.Application”)objExcel.Visible = TrueSet Wb= objExcel.Workbooks.Open (filepath)Wb.worksheets(1).Cells(1,1).Value = “TutorialPoints” read value from Excel file

Discussion

No Comment Found

Related InterviewSolutions

What are Virtual Objects?
What is descriptive programming in UFT means?
In UFT, how to get data from database?
Using UFT, how to send email from outlook?
If the Global Data sheet contains no data and the Local Datasheet contains two rows of data, how many times will the test iterate?
What is the extension for a function library?
In UFT, what is the code to write data to text file?
In UFT, what are the differences between qfl and vbs files?
How Bitmap Check point is differ from Image Check point?
How many types of environment variables QTP supports?

In UFT, how to write data to excel file?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment