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
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 providedExpected Value: Blue | Verification Failed (-16100)DESCRIPTION:The value which is required was not found on the currently active page or view. | Original ValueExpected 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
Feedback sent
We appreciate your effort and will try to fix the article