Working with Excel Object Model in UFT – User friendly Tech help

ByMatteo

In this video tutorial we are going to discuss, working with Excel in UFT using our “Excel Object Model“.
n
nTopics discussed:-

n

    n

  • Understanding Excel object model(Application, Workbooks, Worksheet,Cell)

    • n

  • Creating the corresponding objects for accessing Excel objects

    • n

  • Fetching single cell data from excel

    • n

  • Fetching data from complete Excel

    • n

  • Writing data into Excel Cell

    • n

  • Changing the Font color of cell in Excel

    • n

  • Changing the Background color of cell in Excel

    • n

n

n

n

n

n

n

n

n

Understanding Excel in UFT

n

Sample Code Snippets:-
n

n

'Creating the Excel Object
set objExcel = createobject("excel.application")
'Creating the Workbooks object
set objWB = objExcel.workbooks.open (Path of Excel)
'Creating the sheet object
set objsheet = objwb.worksheets(SheetName)
'Changing the backgound color all the populated cells in sheet
for i= 1 to objsheet.usedrange.rows.count
 for j = 1 to objsheet.usedrange.columns.count objsheet.cells(i,j).interior.color=vbred 
 next
next
'Saving the workbook after changesobjWb.save
'closing the workbookobjWB.close
 'Quit the Excel and destroying the Excel objectobjExcel.Quit
set objExcel=nothing

n

n
n

nIncase below video is not loaded, Click Here
n


n

How to copy Data from Notepad and Paste into Excel
nCode for Adding Hyperlinks in Excel
nHow to get column address from column Name in Excel
nHow to Randomize Excel data?

Was this article helpful?
YesNo

Similar Posts

How to create project in Sonar Qube ? – User friendly Tech help

ByMatteo

Problem:- How we can create(or provision) project using Sonar Qube UI.n n Solution:- We already know that we can Sonar Qube will automatically create a project when we run the code analysis but incase we want to manually provision the project before running the code scanning we can do that. n 1)Login as administrator on…

Understanding Selenium WebDriver Navigation Commands? – User friendly Tech help

ByMatteo

After successfully running our first test case on Firefox and Chrome. We are stepping towards grasping the essential navigation commands in Selenium. Thus we are going to discuss about multifarious browser commands that we would be using in our day to day automation testing. n Requirement :- nHow to navigate in Browser using Selenium Webdriver?nnSolution :-nWe…

Keyword Driven Framework in Automation – User friendly Tech help

ByMatteo

What is a Keyword Framework?nnKeyword Driven Framework refer to an application-independent automation framework, where for a particular test case, we would create an set of keywords and then associate an action (or function) which each of these keyword.These keywords run independent of the test automation tool used to execute them and the test script code that “drives” the application-under-test and…

Creating a salesforce lightning web component in visual studio code – User friendly Tech help

ByMatteo

import { LightningElement, track } from ‘lwc’;nnexport default class HelloLWC extends LightningElement {n //default valuesn @track typedValue = ”;n salutationOptions = [n {‘label’: ‘None’, ‘value’: ‘None’},n {‘label’: ‘Mr.’, ‘value’: ‘Mr.’},n {‘label’: ‘Ms.’, ‘value’: ‘Ms.’},n {‘label’: ‘Mrs.’, ‘value’: ‘Mrs.’},n {‘label’: ‘Dr.’, ‘value’: ‘Dr.’},n {‘label’: ‘Prof.’, ‘value’: ‘Prof.’},n ];nn //method on click of buttonn handleClick(){n const txtInput…

Working with VAPI-XP in ALM ? – User friendly Tech help

ByMatteo

Today we are going to discuss the basics of VAPI-XP and how to create our first VAPI-XP in ALM.nnMeaning:-VAPI-XP testing tool facilitate us to create new testing scripts using Microsoft VBScript, Microsoft JavaScript (JScript version), PerlScript, and PythonScript. Furthermore we can integrate these scipts into our application management process. Using VAPI-XP test scripts, we can…

How to schedule scripts in UFT using AOM and Windows Scheduler? – User friendly Tech help

ByMatteo

Given video tutorial describes about the  basics of AOM (Automation Object Model) and how we can schedule the scripts in UFT using Windows Task Scheduler.nnPlease click the below link to open video directly,nAOM in UFTnnn n nnPlease feel free to share your comments,nnThanks!nnLearning UFTnWhat is Selenium MatteoWas this article helpful?YesNo