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 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 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