Using Utility Keywords - Opkey New UI

Keywords are used by calling them in a test step and adding the input and expected output data values. If you want to capture the dynamic objects, you can also add properties of the object in the test object column. Let's understand this with an example of using the Excel_VerifyCellValue keyword.


Excel_VerifyCellValue

This keyword verifies content available inside any specified cell of an Excel file. It is mostly used to verify the value available within any specified cell.


 It takes ExcelReference, SheetName, Row, Column, and Expected Value as references for input and shares the stored value.


For example, to verify the content inside an Excel file, we can use the following steps:-


1. Add a new step in your test case by clicking the Add Step icon  or the '+' button.


 Search and click on the search result to add it to the new test step.




2. Select the keyword and click on the Set Data to enter the input parameters.




3. Add the input data related to the Excel file as shown below. 



Note: These values are filled as per the requirement of the keyword used in the test case


In this Keyword, there was no requirement to add a Test Object's properties, hence, we have mentioned it is not required.


Test Object 


Test Object Required

Description

None

Not Required


Input Data


 Input Data Required

 Description 

 

ExcelReference

 Specify the Reference Name of the Excel file that is used with the Excel_Open keyword. 

                     SheetName

Specify the Name of the Sheet 

Row

 Specify the Row Number of the cell whose value has to be fetched.

 columnNumber

 Specify the Column Number of the cell whose value has to be fetched.

Expected Value

Specify the Expected Value of the cell


Output Data

Condition

Output value

If the keyword passes successfully

True

if there is an error

False



Common Error conditions

Scenarios

Error Message

Debug Information

If the data Input Arguments are not provided  

Argument Data Missing (-13200) 

DESCRIPTION: 

A step can't proceed without values for mandatory arguments. Unlike optional ones, compulsory arguments must be filled with data, which can come from a static entry, a previous step's output, or a global variable. Leaving them empty is not allowed. 

Argument(s) : (Column) is/are blank.

If an incorrect Expected Value is provided

Expected Value: Blue

Verification Failed (-16100) 

DESCRIPTION: 

The value which is required was not found on the currently active page or view.

Original Value   

Expected Value : 



Now let's go through the list of Utility keywords to understand their utility by clicking here.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article