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