Excel_VerifyCellValue
This keyword verifies content available inside any specified cell of an Excel file. This keyword is mostly used in situations where you have to verify value available within any specified cell.
Note: Excel_Open Keyword is always used prior to this keyword.
Input Arguments
Output
Example
In the given screenshot, suppose you want to Verify the value of the highlighted cell of the Excel File saved on your system then here is how you will use Excel_VerifycellValue keyword:
Excel_VerifycellValue
Common Error conditions
Excel_VerifyColumnCount
This keyword verifies the number of Columns corresponding to the specified Row Number of an Excel file.
Note: ExcelOpen Keyword is always used prior to this keyword.
Input Arguments
Output
Example
In the given screenshot, suppose you want to verify the number of columns corresponding to the specified Row Number of an Excel file saved on your system then here is how you will use Excel_VerifyColumnCount keyword:
Excel_VerifyColumnCount
Common Error conditions
Excel_VerifyRowCount
This keyword verifies the number of rows corresponding to the specified Column Number of an Excel file.
Note: Excel_Open Keyword is always used prior to this keyword.
Input Arguments
Output
Example
In the given screenshot, suppose you want to verify the number of rows corresponding to the specified Column Number of an Excel file saved on your system then here is how you will use Excel_VerifyRowCount keyword:
Excel_VerifyRowCount
Common Error conditions
Excel_ClearCellValue
This keyword is used to clear the value of cell in an Excel file based on the data input arguments provided.
Note: Excel_Open Keyword is always used prior to this keyword.
Input Arguments
Output
Example
In the given screenshot, suppose you want to clear the cell values of the highlighted cells of the Excel File saved on your system then here is how you will use Excel_ClearCellValue keyword:
Excel_ClearCellValue
Common Error conditions
Excel_ClearColumn
This keyword is used to clear column (s) of Excel file based on the data input argument provided.
Note: Excel_Open Keyword is always used prior to this keyword.
Input Arguments
Output
Example
In the given screenshot, suppose you want to clear the Column values of the highlighted Column cells of the Excel File saved on your system then here is how you will use Excel_ClearColumn keyword:
Excel_ClearColumn
Common Error conditions
Excel_ClearRows
This keyword is used to clear Row(s) of Excel file based on the data input argument provided.
Note: Excel_Open Keyword is always used prior to this keyword.
Input Arguments
Output
Example
In the given screenshot, suppose you want to clear the Row values of the highlighted row cells of the Excel File saved on your system then here is how you will use Excel_ClearRows keyword:
Excel_ClearRows
Common Error conditions
Excel_Close
This keyword will 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.
Input Arguments
Output
Example
Suppose you want to close the currently opened Excel reference File saved on your system then here is how you will use Excel_Close keyword:
Excel_Close
Common Error conditions
Excel_CloseAll
This keyword closes all the opened Excel File.
Note: Excel_Open Keyword is always used prior to this keyword.
Input Arguments
Output
Example
Suppose you want to close all the opened Excel File saved on your system then you can use Excel_CloseAll keyword.
Common Error conditions
There are no error conditions for this keyword.
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 prior to this keyword.
Input Arguments
Output
Example
In the given screenshot, suppose you want to compares the values of the highlighted cells of an Excel file saved on your system then here is how you will use Excel_CompareCellValue keyword:
Excel_CompareCellValue
Common Error conditions
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 prior to this keyword.
Input Arguments
Output
Example
In the given screenshot, suppose you want to compares the values of the highlighted columns of an Excel file saved on your system then here is how you will use Excel_CompareColumns keyword:
Excel_CompareColumns
Note:
The value of the delimiter is Semicolon(;) by default.
Common Error conditions
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.
Input Arguments
Output
Example
In the given screenshot, suppose you want to compares the values of the highlighted rows of an Excel file saved on your system then here is how you will use Excel_CompareRows keyword:
Excel_CompareRows
Note:
The value of the delimiter is Semicolon(;) by default.
Common Error conditions
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.
Input Arguments
Output
Example
Suppose you want to compares the values of the two Excel sheets with in different excel file saved on your system then here is how you will use Excel_CompareSheet keyword:
Excel_CompareSheet
Common Error conditions
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.
Input Arguments
Output
Example
In the given screenshot, suppose you want to copy the value of the highlighted cell and then paste it on another cell of an Excel Sheet then here is how you will use Excel_CopyAndPasteCellValue keyword:
Excel_CopyAndPasteCellValue
Output
Common Error conditions
Excel_CreateaFile
This keyword is used to create a new Excel file, it supports only .xlsx and xls format file. It takes File path and Sheet name (optional) as data input arguments.
Input Arguments
Output
Example
Suppose you want to create an Excel File and save it on your system then here is how you will use Excel__CreateFile keyword:
Excel__CreateFile
Note: Specify the Excel Path of the file with .xlsx or xls Extension
Common Error conditions
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.
Input Arguments
Output
Example
In the given screenshot, suppose you want to Delete the highlighted row of an Excel File saved on your system then here is how you will use Excel_DeleteRow keyword:
Excel_DeleteRow
Common Error conditions
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.
Input Arguments
Output
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
Output
Common Error conditions
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.
Input Arguments
Output
Example
In the given screenshot, suppose you want to fetch the value of the highlighted cell of the Excel File saved on your system then here is how you will use Excel_GetcellValue keyword:
Excel_GetcellValue
Common Error conditions
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.
Input Arguments
Output
Example
In the given screenshot, suppose you want to Get the number of columns of an Excel File saved on your system then here is how you will use Excel_GetColumnCount keyword:
Excel_GetColumnCount
Common Error conditions
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.
Input Arguments
Output
Example
In the given screenshot, suppose you want to fetch the values of the highlighted column separated by Delimiter of an Excel file saved on your system then here is how you will use Excel_GetColumnValue keyword:
Excel_GetColumnValue
Note:
The value of the delimiter is Semicolon(;) by default.
Output
Green#Yellow#Orange#Violet#Royal Blue
Common Error conditions
Excel_GetRowCount
This Keyword Returns the number of Rows in the specified Excel file. This keyword is used in a situation where user wants Row Count of an Excel file with the help of Column Number.
Note: Excel_Open Keyword is always used prior to this keyword.
Input Arguments
Output
Example
In the given screenshot, suppose you want to Get the number of rows of an Excel File saved on your system then here is how you will use Excel_GetRowCount keyword:
Excel_GetRowCount
Common Error conditions
Excel_GetRowValue
This keyword will fetch the value from a specified Row of an Excel File based on the Data Input Arguments provided.
Note: ExcelOpen Keyword is always used prior to this keyword.
Input Arguments
Output
Example
In the given screenshot, suppose you want to fetch the values of the highlighted row separated by Delimiter of an Excel file saved on your system then here is how you will use Excel_GetRowValue keyword:
Excel_GetRowValue
Note:
The value of the delimiter is Semicolon(;) by default.
Output
Yellow#White#Brown
Common Error conditions
Excel_InsertBlankRows
This keyword is used to insert the blank row (s) in the Excel sheet of a particular Excel file based on the data input arguments provided.
Note: ExcelOpen Keyword is always used prior to this keyword. The Excel File must be closed before using this Keyword.
Input Arguments
Output
Example
In the given screenshot, suppose you want to Insert 2 blank rows after row number 2 in an Excel Sheet of an Excel file saved on your system then here is how you will use Excel_InsertBlankRows keyword:
Excel_InsertBlankRows
This keyword will insert blank rows as follows:
Common Error conditions
Excel_Open
This keyword will open an Excel File. It takes ExcelFile and ExcelReference (which can be referenced for other Excel keywords) as Data Input Arguments.
Input Arguments
Output
Example
Suppose you want to open an Excel File saved on your system then here is how you will use Excel_Open keyword:
Excel_Open
Common Error conditions
Excel_RenameSheet
This keyword is used to rename a particular Excel sheet within the Excel file based on the data input arguments provided.
Note: Excel_Open Keyword is always used prior to this keyword.
Input Arguments
Output
Example
In the given screenshot, suppose you want to change the name of the highlighted sheet of the Excel File saved on your system then here is how you will use Excel_RenameSheet keyword:
Excel_RenameSheet
Common Error conditions
Excel_SetBackGroundColor
This keyword is used to set background Color of a particular cell in 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.
Input Arguments
Output
Example
In the given screenshot, suppose you want to set the background color of the highlighted cell of the Excel File saved on your system then here is how you will use Excel_SetCellBackgroundColor keyword:
Excel_SetCellBackgroundColor
This keyword will set the Color of the specified cell as Blue(w.r.t the figure)
Note:
You can provide any of the following listed colors as the Background Color [Data Input Argument].
Common Error conditions
Excel_SetCellTextColor
This keyword is used to set a Text Color of a particular cell in 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.
Input Arguments
Output
Example
In the given screenshot, suppose you want to set the Text color of the highlighted cell of the Excel File saved on your system then here is how you will use Excel_SetCellTextColor keyword:
Excel_SetCellTextColor
This keyword will set the Text Color of the specified cell as Blue(w.r.t the figure)
Note:
You can provide any of the following listed colors as the Text Color [Data Input Argument].
Common Error conditions
Excel_SetRowValue
This keyword is used to set the Value of a specified Row in an Excel sheet of 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.
Input Arguments
Output
Example
In the given screenshot, suppose you want to set values in the highlighted row of an Excel file saved on your system then here is how you will use Excel_SetRowValue keyword:
Excel_SetRowValue
Note:
The value of the delimiter is Semicolon(;) by default.
Output
Common Error conditions
Excel_SetColumnValue
This keyword is used to set the Value of a specified Column in an Excel sheet of 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 Keywword.
Input Arguments
Output
Example
In the given screenshot, suppose you want to set values in the highlighted Column of an Excel file saved on your system then here is how you will use Excel_SetColumnValue keyword:
Excel_SetColumnValue
Note:
The value of the delimiter is Semicolon(;) by default.
Output
Common Error conditions
Excel_UtilityPressKeys
This Keyword press keys to the native application window. It takes keys as Data input argument.
Input Arguments
Output
Example
Suppose you want to press Enter key then here is how you will use Utility_PressKeys keyword:
Utility_PressKeys
Note: The key Name is always provided within { } brackets.
Common Error conditions
Excel_SetCellValue
This keyword is used to set a Cell value in 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.
Input Arguments
Output
Example
In the given screenshot, suppose you want to set the value of the highlighted Cell of an Excel File saved on your system then here is how you will use Excel_SetCellValue keyword:
Excel_SetCellValue
Common Error conditions