To learn how to use Utility keywords in Opkey, you can read Using Utility Keywords - New UI and Using Utility Keywords - Opkey Classic. Now, let's go through the list of Web keywords and their utility.
Excel_VerifyColumnCount
This keyword verifies the number of Columns corresponding to the specified Row Number of an Excel file.
Note: The Excel_Open Keyword is always used before this keyword.
Example
Test Object
Input Data
Output Data
Error conditions
3. Excel_VerifyRowCount
This keyword verifies the number of rows corresponding to the specified Column Number of an Excel file.
Note: The Excel_Open Keyword is always used before this keyword.
Example
Test Object
Input Data
Output Data
Error conditions
4. Excel_ClearCellValue
This keyword clears the value of a cell in an Excel file based on the data input arguments provided.
Note: Excel_Open Keyword is always used before this keyword.
Example
Example
Test Object
Input Data
Output Data
Error conditions
5. Excel_ClearColumn
This keyword clears column (s) of the Excel file based on the data input argument provided.
Note: Excel_Open Keyword is always used prior to this keyword.
Test Object
Input Data
Output Data
Error conditions
6. Excel_ClearRows
This keyword clears Row(s) of Excel file based on the data input argument provided.
Note: Excel_Open Keyword is always used prior to this keyword.
Example :-
Excel_ClearRows
Test Object
Input Data
Output Data
Error conditions
7. Excel_Close
This keyword helps close the currently opened Excel reference File. It takes Excel Reference as Data Input Arguments.
Note: Excel_Open Keyword is always used prior to this keyword.
Example
Test Object
Input Data
Output Data
Error conditions
8. Excel_CloseAll
This keyword closes all the opened Excel File.
Note: Excel_Open Keyword is always used prior to this keyword.
Example
Suppose you want to close all the opened Excel files saved on your system then you can use Excel_CloseAll keyword.
Test Object
Input Data
Output Data
Error conditions
There are no error conditions for this keyword.
9. Excel_CompareCellValue
This Keyword compares the values of two specified cells within the same Excel file or two different Excel files based on the Data Input Arguments provided.
Note: Excel_Open Keyword is always used before this keyword.
Example:-
Excel_CompareCellValue
Test Object
Input Data
Output Data
Error conditions
10. Excel_CompareColumns
This Keyword compares the values of two specified Columns within the same Excel file or two different Excel files based on the Data Input Arguments provided.
Note: Excel_Open Keyword is always used before this keyword.
Example:-
Excel_CompareColumns
Note:
The value of the delimiter is Semicolon(;) by default.
Test Object
Input Data
Output Data
Error conditions
11. Excel_CompareRows
This Keyword compares the values of two specified Rows within the same excel file or two different Excel files based on the Data Input Arguments provided.
Note: Excel_Open Keyword is always used prior to this keyword.
Example :-
Excel_CompareRows
Note:
The value of the delimiter is Semicolon(;) by default.
Test Object
Input Data
Output Data
Error conditions
12. Excel_CompareSheet
This keyword is used to compare two Excel sheets with in single excel file or two different excel file based on data input arguments provided.
Note: Excel_Open Keyword is always used prior to this keyword.
Example
Test Object
Input Data
Output Data
Error conditions
13. Excel_CopyAndPasteCellValue
This keyword is used to copy and paste particular cell value (s) within single excel sheet or within two different excel sheet or within 2 different excel sheets of 2 different excel files based on the Data Input Arguments provided.
Note: Excel_Open Keyword is always used prior to this keyword. The Excel File must be closed before using this Keyword.
Example :-
Excel_CopyAndPasteCellValue
Test Object
Input Data
Output Data
Error conditions
14. Excel_CreateFile
This keyword creates a new Excel file, it supports only .xlsx and xls format file. It takes File path and Sheet name (optional) as data input arguments.
Note: Specify the Excel Path of the file with .xlsx or xls Extension
Test Object
Input Data
Output Data
Error conditions
15. Excel_DeleteRow
This keyword is used to delete row(s) from the particular Excel sheet based on the data input arguments provided.
Note: Excel_Open Keyword is always used prior to this keyword.
Example :-
Excel_DeleteRow
Test Object
Input Data
Output Data
Error conditions
16. Excel_DuplicateSheet
This keyword is used to create a duplicate copy of an Excel sheet within an Excel File based on the data input arguments provided.
Note: Excel_Open Keyword is always used prior
to this keyword.The Excel File must be closed before using this Keyword.
Example
Suppose you want to Create a Duplicate Sheet of an Excel Sheet within an Excel File saved on your system then here is how you will use Excel_DuplicateSheet keyword:
Excel_DuplicateSheet
Test Object
Input Data
Output Data
Error conditions
17. Excel_GetCellValue
This keyword will fetch the value from a specified cell of an Excel File based on the Data Input Arguments provided.
Note: Excel_Open Keyword is always used prior to this keyword.
Example
Excel_GetcellValue
Test Object
Input Data
Output Data
Error conditions
18. Excel_GetColumnCount
This Keyword Returns the number of columns in the specified Excel file. This keyword is used in a situation where user wants the Column Count of an Excel file with the help of Row Number.
Note: Excel_Open Keyword is always used prior to this keyword.
Example
Excel_GetColumnCount
Test Object
Input Data
Output Data
Error conditions
19. Excel_GetColumnValue
This keyword will fetch the value from a specified Column of an Excel File based on the Data Input Arguments provided.
Note: Excel_Open Keyword is always used prior to this keyword.
Example