17.10 Utility Keywords

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

1.jpg

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

1.jpg

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

1.jpg

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

1.jpg

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

1.jpg

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

1.jpg

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

1.jpg

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

1.jpg

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

1.jpg

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

1.jpg

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

1.jpg

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

1.jpg

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

1.jpg

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

1.jpg

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

1.jpg

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:

1.jpg

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

1.jpg

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

1.jpg

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

1.jpg

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

1.jpg

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

1.jpg

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

1.jpg

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

1.jpg

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

Article

No items found.