Highlighted
Trusted Contributor.. Trusted Contributor..
Trusted Contributor..
458 views

UFT 14.50 How to set value in Cells Microsoft Excel 2016

ear Team,

We have test UFT 14.50 for SAP Analysis 2.7 .

We use UI Automation , we could read data from excel, but how we should insert data to excel.

This script doest work

Execute "Set Excel_GetExcelObj = GetObject(, ""Excel.Application"")"
Set objSheet = Excel_GetExcelObj.ActiveSheet
Set objCell = objSheet.Cells(18, 5)
objCell.Value = "999"

 

Tags (3)
0 Likes
1 Reply
Highlighted
Micro Focus Expert
Micro Focus Expert

Re: UFT 14.50 How to set value in Cells Microsoft Excel 2016

What has been executed is purely vbscript but not UFT UIAutomation related scripts, does it run fine in a vbs file?

Did you try UI Automation addin in UFT to see how it goes?

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.