Using Excel Keywords - Opkey New UI

How to use Keywords? 

 

To use keywords, include them in a test step and provide input and expected output data. To capture dynamic objects, add their properties in the test object column. For instance, consider using the Excel_VerifyCellValue keyword. 

 

 

This keyword verifies content available inside any specified cell of an Excel file. This is used when you need to check the value in a specific cell. 

  

It takes ExcelReferenceSheetName, 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 button. It can also be done by clicking on the icon on the panel as shown in the image below. Search Excel_VerifyCellValue and click on the search result to add it to the new test step. 


 
2. Click the Step input data icon in the input data column of the step to open the input data window for the keyword. 

 
 



3. Add the input data related to the Excel file as shown below, by clicking on the Set Input Data.  

 




These values are filled as per the keyword requirement used in the test case as shown in the image below. We have given similar tables for each keyword for illustration.  
 
In this Keyword, there was no requirement to add a Test Object's properties. 
 

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 must be fetched. 

 ColumnNumber 

Specify the Column Number of the cell whose value must 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 required value was not found on the currently active page or view. 

Original Value    

Expected Value :  

 

Please go through them by clicking the link given below. 

List of Keywords - Excel Keywords

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