25.7 Excel 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
|
Object Input Arguments |
Required? |
Description |
|
Object |
No |
This keyword does not require any object Input Argument. |
|
Data Input Arguments |
Required? |
Description |
|
ExcelReference |
Yes |
Specify the Reference Name of the Excel file which is used with Excel_Open keyword. |
|
SheetName |
Yes |
Specify the Name of the Sheet |
|
Row |
Yes |
Specify the Row Number of the cell whose value has to be fetched. |
|
Column |
Yes |
Specify the Column Number of the cell whose value has to be fetched. |
|
Expected Value |
Yes |
Specify the Expected Value of the cell |
Output
|
True
|
If the keyword passes successfully |
|
False |
If the keyword fails |
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
|
ExcelReference |
abcd |
|
SheetName |
Colors |
|
Row |
1 |
|
Column |
1 |
|
Expected Value |
Green |
Common Error conditions
|
Scenarios |
Error Message |
Debug Information |
|
If the data Input Arguments are not provided |
Argument Data Missing (-13200) DESCRIPTION: A step could not be executed because one or more of the arguments have not been provided a value. Of all the arguments a keyword accepts, some arguments might be compulsory. As opposed to the non-compulsory ones, the compulsory argument must be provided some data. The data may be provided through one of many sources like statically entering, output of a previous step, a global variable etc; but it must not be left blank. |
Argument(s) : (Column) is/are blank. |
|
If incorrect Expected Value is provided Expected Value : Blue |
Verification Failed (-16100) DESCRIPTION: The value which is required, was not found on the currently active page or view. |
Original Value Expected Value : |
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
|
Object Input Arguments |
Required? |
Description |
|
Object |
No |
This keyword does not require any object Input Argument. |
|
Data Input Arguments |
Required? |
Description |
|
Excel Reference |
Yes |
Specify the Reference Name of the Excel file which is used with Excel_Open keyword. |
|
Sheet Name |
Yes |
Specify the Name of the Sheet whose number of Columns has to be Verified |
|
Row |
Yes |
Specify the Row Number which will be used to Verify the Column count. |
|
Expected Count |
Yes |
Specify the Expected count of columns corresponding to the specified Row Number of an Excel file |
Output
|
True |
If the keyword passes successfully |
|
False |
If an error is there |
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
|
ExcelReference |
abcd |
|
SheetName |
Colors |
|
Row |
5 |
|
Expected Count |
3 |
Common Error conditions
|
Scenarios |
Error Message |
Debug Information |
|
If blank data Input Arguments are provided. |
Argument Data Missing (-13200)
DESCRIPTION: A step could not be executed because one or more of the arguments have not been provided a value. Of all the arguments a keyword accepts, some arguments might be compulsory. As opposed to the non-compulsory ones, the compulsory argument must be provided some data. The data may be provided through one of many sources like statically entering, output of a previous step, a global variable etc; but it must not be left blank. |
Argument(s) : (ExcelReference; SheetName;Row) is/are blank. |
|
If the keyword is launched without using Excel Open keyword. |
Conflicting Configuration (-14400)
DESCRIPTION: Some system/application specific settings are preventing this operation. Watch for the applications involved in the current operation. Some of these applications have been wrongly configured. You need to tweak some settings, edit some configuration file, turn a few knobs. The nature and scope of the adjustment will depend on the exact problem faced. |
Excel Reference is not opened. |
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
|
Object Input Arguments |
Required? |
Description |
|
Object |
No |
This keyword does not require any object Input Argument. |
|
Data Input Arguments |
Required? |
Description |
|
Excel Reference |
Yes |
Specify the Reference Name of the Excel file which is used with Excel_Open keyword. |
|
Sheet Name |
Yes |
Specify the Name of the Sheet whose number of Rows has to be verified |
|
Column |
Yes |
Specify the Column Number which will be used to verify the Row count. |
|
Expected Count |
Yes |
Specify the Expected count of rows corresponding to the specified Column Number of an Excel file |
Output
|
True |
If the keyword passes successfully |
|
False |
If an error is there |
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
|
ExcelReference |
abcd |
|
SheetName |
Colors |
|
Column |
1 |
|
Expected Count |
5 |
Common Error conditions
|
Scenarios |
Error Message |
Debug Information |
|
If blank data Input Arguments are provided. |
Argument Data Missing (-13200)
DESCRIPTION: A step could not be executed because one or more of the arguments have not been provided a value. Of all the arguments a keyword accepts, some arguments might be compulsory. As opposed to the non-compulsory ones, the compulsory argument must be provided some data. The data may be provided through one of many sources like statically entering, output of a previous step, a global variable etc; but it must not be left blank. |
Argument(s) : (ExcelReference; SheetName;Column) is/are blank. |
|
If the keyword is launched without using Excel Open keyword. |
Conflicting Configuration (-14400)
DESCRIPTION: Some system/application specific settings are preventing this operation. Watch for the applications involved in the current operation. Some of these applications have been wrongly configured. You need to tweak some settings, edit some configuration file, turn a few knobs. The nature and scope of the adjustment will depend on the exact problem faced. |
Excel Reference is not opened. |
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
|
Object Input Arguments |
Required? |
Description |
|
Object |
No |
This keyword does not require any object Input Argument. |
|
Data Input Arguments |
Required? |
Description |
|
ExcelReference |
Yes |
Specify the Reference Name of the Excel file which is used with ExcelOpen keyword. |
|
SheetName |
Yes |
Specify the Name of the Sheet whose Cell Value has to be cleared |
|
StartingRow |
Yes |
Specify the Starting Row from where the values/data has to be deleted. |
|
StartingColumn |
Yes |
Specify the Starting Column from where the values/data has to be deleted. |
|
EndingRow |
Yes |
Specify the Ending Row till where the values/data has to be deleted. |
|
EndingColumn |
Yes |
Specify the Ending Column till where the values/data has to be deleted. |
Output
|
True |
If the keyword passes successfully |
|
False |
If the keyword fails |
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
|
ExcelReference |
abcd |
|
SheetName |
Colors |
|
StartingRow |
1 |
|
StartingColumn |
1 |
|
EndingRow |
4 |
|
EndingColumn |
2 |
Common Error conditions
|
Scenarios |
Error Message |
Debug Information |
|
If the keyword is executed without closing the Excel file on the system. |
Conflicting Configuration (-14400)
DESCRIPTION: Some system/application specific settings are preventing this operation. Watch for the applications involved in the current operation. Some of these applications have been wrongly configured. You need to tweak some settings, edit some configuration file, turn a few knobs. The nature and scope of the adjustment will depend on the exact problem faced. |
Close the Excel File to modify the data on the file. |
|
If the keyword is launched without using Excel Open keyword. |
Conflicting Configuration (-14400)
DESCRIPTION: Some system/application specific settings are preventing this operation. Watch for the applications involved in the current operation. Some of these applications have been wrongly configured. You need to tweak some settings, edit some configuration file, turn a few knobs. The nature and scope of the adjustment will depend on the exact problem faced. |
Excel Reference is not opened. |
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
|
Object Input Arguments |
Required? |
Description |
|
Object |
No |
This keyword does not require any object Input Argument. |
|
Data Input Arguments |
Required? |
Description |
|
Excel Reference |
Yes |
Specify the Reference Name of the Excel file which is used with Excel_Open keyword. |
|
SheetName |
Yes |
Specify the Name of the Sheet whose Column Values has to be cleared |
|
Starting Column Number |
Yes |
Specify the Starting Column from where the values/data has to be cleared. |
|
Number of Columns |
Yes |
Specify the Number of Columns whose value has to be cleared |
Output
|
True
|
If the keyword passes successfully |
|
False |
If the keyword fails |
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
|
ExcelReference |
abcd |
|
SheetName |
Colors |
|
Starting Column Number |
1 |
|
Number of Columns |
2 |
Common Error conditions
|
Scenarios |
Error Message |
Debug Information |
|
If blank data Input Arguments are provided. |
Argument Data Missing (-13200)
DESCRIPTION: A step could not be executed because one or more of the arguments have not been provided a value. Of all the arguments a keyword accepts, some arguments might be compulsory. As opposed to the non-compulsory ones, the compulsory argument must be provided some data. The data may be provided through one of many sources like statically entering, output of a previous step, a global variable etc; but it must not be left blank. |
Argument(s) : (SheetName; StartingColumn Number; NumberOf Columns) is/are blank. |
|
If the keyword is launched without using Excel Open keyword. |
Conflicting Configuration (-14400) DESCRIPTION: Some system/application specific settings are preventing this operation. Watch for the applications involved in the current operation. Some of these applications have been wrongly configured. You need to tweak some settings, edit some configuration file, turn a few knobs. The nature and scope of the adjustment will depend on the exact problem faced. |
Excel Reference is not opened. |
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
|
Object Input Arguments |
Required? |
Description |
|
Object |
No |
This keyword does not require any object Input Argument. |
|
Data Input Arguments |
Required? |
Description |
|
ExcelReference |
Yes |
Specify the Reference Name of the Excel file which is used with Excel_Open keyword. |
|
SheetName |
Yes |
Specify the Name of the Sheet whose Column Values has to be cleared |
|
Starting Row Number |
Yes |
Specify the Starting Row from where the values/data has to be cleared. |
|
Number of Rows |
Yes |
Specify the Number of Rows whose value has to be cleared. |
Output
|
True |
If the keyword passes successfully |
|
False |
If the Keyword fails |
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
|
ExcelReference |
abcd |
|
SheetName |
Colors |
|
Starting Row Number |
4 |
|
Number of Rows |
2 |
Common Error conditions
|
Scenarios |
Error Message |
Debug Information |
|
If blank data Input Arguments are provided. |
Argument Data Missing (-13200)
DESCRIPTION: A step could not be executed because one or more of the arguments have not been provided a value. Of all the arguments a keyword accepts, some arguments might be compulsory. As opposed to the non-compulsory ones, the compulsory argument must be provided some data. The data may be provided through one of many sources like statically entering, output of a previous step, a global variable etc; but it must not be left blank. |
Argument(s) : (SheetName;Starting RowNumber;Number OfRows) is/are blank. |
|
If the keyword is launched without using Excel Open keyword. |
Conflicting Configuration (-14400)
DESCRIPTION: Some system/application specific settings are preventing this operation. Watch for the applications involved in the current operation. Some of these applications have been wrongly configured. You need to tweak some settings, edit some configuration file, turn a few knobs. The nature and scope of the adjustment will depend on the exact problem faced. |
Excel Reference is not opened. |
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
|
Object Input Arguments |
Required? |
Description |
|
Object |
No |
This keyword does not require any object Input Argument. |
|
Data Input Arguments |
Required? |
Description |
|
ExcelReference |
Yes |
Specify the Reference Name of the Excel file which is used with ExcelOpen keyword. |
Output
|
True |
If the keyword passes successfully |
|
False |
If the Keyword Fails |
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
|
ExcelReference |
abcd |
Common Error conditions
|
Scenarios |
Error Message |
Debug Information |
|
If the data Input Arguments are not provided |
Argument Data Missing (-13200)
DESCRIPTION: A step could not be executed because one or more of the arguments have not been provided a value. Of all the arguments a keyword accepts, some arguments might be compulsory. As opposed to the non-compulsory ones, the compulsory argument must be provided some data. The data may be provided through one of many sources like statically entering, output of a previous step, a global variable etc; but it must not be left blank. |
Argument(s) Excel Reference is/are blank. |
|
If the keyword is launched without using Excel Open keyword. |
Argument Data Invalid (-13300)
DESCRIPTION: The data value for one or more input arguments was not what was expected. This might happen when the input is expected in a specific format or should be chosen from a predefined set of values. Check for spell errors and casing. |
Specified Excel Reference is not opened or already closed |
Excel_CloseAll
This keyword closes all the opened Excel File.
Note: Excel_Open Keyword is always used prior to this keyword.
Input Arguments
|
Object Input Arguments |
Required? |
Description |
|
Object |
No |
This keyword does not require any object Input Argument. |
|
Data Input Arguments |
Required? |
Description |
|
Data |
No |
This keyword does not require any Data Input Argument. |
Output
|
True
|
If the keyword passes successfully |
|
False |
If the keyword fails |
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
|
Object Input Arguments |
Required? |
Description |
|
Object |
No |
This keyword does not require any object Input Argument. |
|
Data Input Arguments |
Required? |
Description |
|
ExcelReference1 |
Yes |
Specify the Reference Name of the Excel file which is used with Excel_Open keyword. |
|
SheetName1 |
Yes |
Specify the Name of the Sheet whose Cell Value has to be compared. |
|
Row1 |
Specify the Row Number of the Excel Sheet whose Cell Value has to be compared. |
|
|
Column1 |
Yes |
Specify the Column Number of the Excel Sheet whose Cell value have to be compared |
|
Excel Reference2 |
Yes |
Specify the Reference Name of the Excel file which is used with Excel_Open keyword. |
|
SheetName2 |
Yes |
Specify the Name of the Sheet whose Cell Value has to be compared. |
|
Row2 |
Yes |
Specify the other Row Number of the Excel Sheet whose Cell Value has to be compared. |
|
Column2 |
Yes |
Specify the other Column Number of the Excel Sheet whose Cell value have to be compared |
Output
|
True |
If the keyword passes successfully |
|
False |
If the two values are not matched or If the keyword fails |
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
|
Excel Reference1 |
abcd |
|
SheetName1 |
Colors |
|
Row1 |
1 |
|
Column1 |
1 |
|
Excel Reference2 |
abcd |
|
SheetName2 |
Colors |
|
Row2 |
1 |
|
Column2 |
2 |
Common Error conditions
|
Scenarios |
Error Message |
Debug Information |
|
If provided values are not matched. |
Verification Failed (-16100)
DESCRIPTION: The value which is required, was not found on the currently active page or view. |
1st Cell < Green > 2nd Cell < Black > |
|
If Blank Data Input Argunments are provided. |
Argument Data Missing (-13200)
DESCRIPTION: A step could not be executed because one or more of the arguments have not been provided a value. Of all the arguments a keyword accepts, some arguments might be compulsory. As opposed to the non-compulsory ones, the compulsory argument must be provided some data. The data may be provided through one of many sources like statically entering, output of a previous step, a global variable etc; but it must not be left blank. |
Argument(s) : (ExcelReference1; SheetName1 ;Row1;Column1;Excel Reference2; SheetName2;Row2; Column2) is/are blank. |
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
|
Object Input Arguments |
Required? |
Description |
|
Object |
No |
This keyword does not require any object Input Argument. |
|
Data Input Arguments |
Required? |
Description |
|
ExcelReference1 |
Yes |
Specify the Reference Name of the Excel file which is used with Excel_Open keyword. |
|
SheetName1 |
Yes |
Specify the Name of the Sheet whose Column Value has to be compared. |
|
Column1 |
Specify the Column Number of the Excel Sheet whose Value has to be compared. |
|
|
ExcelReference2 |
Yes |
Specify the Reference Name of the Excel file which is used with Excel_Open keyword. |
|
SheetName2 |
Yes |
Specify the Name of the Sheet whose Column Values has to be compared. |
|
Column2 |
Yes |
Specify the other Column Number of the Excel Sheet whose Column Value has to be compared. |
|
Delimiter |
No |
Specify the text/symbol/special characters by which the Column text has to be separated. |
Output
|
True |
If the keyword passes successfully |
|
False |
If the values of the row are not matched or If the keyword fails |
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
|
Excel Reference1 |
abcd |
|
SheetName1 |
Colors |
|
Column1 |
1 |
|
Excel Reference2 |
abcd |
|
SheetName2 |
Colors |
|
Column2 |
2 |
|
Delimiter |
Note:
The value of the delimiter is Semicolon(;) by default.
Common Error conditions
|
Scenarios |
Error Message |
Debug Information |
|
If the two row values are not matched. |
Verification Failed (-16100)
DESCRIPTION: The value which is required, was not found on the currently active page or view.
|
1st Column: Green ;Blue> 2nd Column:
|
|
If Blank Data Input Argunments are provided. |
Argument Data Missing (-13200)
DESCRIPTION: A step could not be executed because one or more of the arguments have not been provided a value. Of all the arguments a keyword accepts, some arguments might be compulsory. As opposed to the non-compulsory ones, the compulsory argument must be provided some data. The data may be provided through one of many sources like statically entering, output of a previous step, a global variable etc; but it must not be left blank. |
Argument(s) : (ExcelReference1;Sheet Name1; Column1;Excel Reference2;Sheet Name2; Column2) is/are blank. |
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
|
Object Input Arguments |
Required? |
Description |
|
Object |
No |
This keyword does not require any object Input Argument. |
|
Data Input Arguments |
Required? |
Description |
|
ExcelReference1 |
Yes |
Specify the Reference Name of the Excel file which is used with Excel_Open keyword. |
|
SheetName1 |
Yes |
Specify the Name of the Sheet whose Row Value has to be compared. |
|
Row1 |
Specify the Row Number of the Excel Sheet whose Row Values has to be compared. |
|
|
ExcelReference2 |
Yes |
Specify the Reference Name of the Excel file which is used with Excel_Open keyword. |
|
SheetName2 |
Yes |
Specify the Name of the Sheet whose Row Values has to be compared. |
|
Row2 |
Yes |
Specify the other Row Number of the Excel Sheet whose Row Value has to be compared. |
|
Delimiter |
No |
Specify the text/symbol/special characters by which the Row text has to be separated. |
Output
|
True
|
If the keyword passes successfully |
|
False |
If the values of the row are not matched or If the keyword fails |
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
|
Excel Reference1 |
abcd |
|
SheetName1 |
Colors |
|
Row1 |
1 |
|
Excel Reference2 |
abcd |
|
SheetName2 |
Colors |
|
Row2 |
1 |
|
Delimiter |
Note:
The value of the delimiter is Semicolon(;) by default.
Common Error conditions
|
Scenarios |
Error Message |
Debug Information |
|
If the two row values are not matched. |
Verification Failed (-16100)
DESCRIPTION: The value which is required, was not found on the currently active page or view.
|
1st Row :< Green ;Green ;Blue > 2nd Row :< Yellow ;White;Brown >
|
|
If Blank Data Input Argunments are provided. |
Argument Data Missing (-13200)
DESCRIPTION: A step could not be executed because one or more of the arguments have not been provided a value. Of all the arguments a keyword accepts, some arguments might be compulsory. As opposed to the non-compulsory ones, the compulsory argument must be provided some data. The data may be provided through one of many sources like statically entering, output of a previous step, a global variable etc; but it must not be left blank. |
Argument(s) : (ExcelReference1; SheetName1;Row1; Column1;Excel Reference2 ;SheetName2;Row2 ;Column2) is/are blank. |
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
|
Object Input Arguments |
Required? |
Description |
|
Object |
No |
This keyword does not require any object Input Argument. |
|
Data Input Arguments |
Required? |
Description |
|
ExcelReference1 |
Yes |
Specify the Reference Name of the Excel file which is used with Excel_Open keyword. |
|
SheetName1 |
Yes |
Specify the Name of the Sheet which has to be compared. |
|
ExcelReference2 |
Yes |
Specify the Reference Name of the Excel file which is used with Excel_Open keyword. |
|
SheetName2 |
Yes |
Specify the Name of the other Sheet which has to be compared |
|
Delimiter |
No |
Specify the text/symbol/special characters by which the text of the two sheets are separated. |
Output
|
True |
If the keyword passes successfully |
|
False |
If the values of the row are not matched or If the keyword fails |
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
|
Excel Reference1 |
abcd |
|
SheetName1 |
Colors |
|
Excel Reference2 |
Mysheet |
|
SheetName2 |
Stars |
|
Delimiter |
Common Error conditions
|
Scenarios |
Error Message |
Debug Information |
|
If the two row values are not matched. |
Verification Failed (-16100)
DESCRIPTION: The value which is required, was not found on the currently active page or view.
|
1st Excel :< Green ;Green ;BlueYellow ;Yellow ;BrownOrange ;Orange ;Lime Orange ;Orange ;Lime Royal Blue;Royal Blue; Light Brown > 2nd Excel :< ab;787fd;grfhv;768 > |
|
If Blank Data Input Argunments are provided. |
Argument Data Missing (-13200)
DESCRIPTION: A step could not be executed because one or more of the arguments have not been provided a value. Of all the arguments a keyword accepts, some arguments might be compulsory. As opposed to the non-compulsory ones, the compulsory argument must be provided some data. The data may be provided through one of many sources like statically entering, output of a previous step, a global variable etc; but it must not be left blank. |
Argument(s) : (ExcelReference1; SheetName1; ExcelReference2; SheetName2) is/are blank. |
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
|
Object Input Arguments |
Required? |
Description |
|
Object |
No |
This keyword does not require any object Input Argument. |
|
Data Input Arguments |
Required? |
Description |
|
ExcelReference1 |
Yes |
Specify the Reference Name of the Excel file which is used with Excel_Open keyword. |
|
SheetName1 |
Yes |
Specify the Name of the Sheet whose Cell Value has to be Copied. |
|
Row1 |
Specify the Row Number of the Excel Sheet whose Cell Value has to be Copied. |
|
|
Column1 |
Yes |
Specify the Column Number of the Excel Sheet whose Cell value have to be Copied |
|
Excel Reference2 |
Yes |
Specify the Reference Name of the Excel file which is used with Excel_Open keyword. |
|
SheetName2 |
Yes |
Specify the Name of the Sheet in which the Cell Value of the copied cell has to be Pasted. |
|
Row2 |
Yes |
Specify the other Row Number of the Excel Sheet where the Cell Value of the copied cell has to be Pasted. |
|
Column2 |
Yes |
Specify the other Column Number of the Excel Sheet where the Cell Value of the copied cell has to be Pasted. |
Output
|
True |
If the keyword passes successfully |
|
False |
If the keyword fails |
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
|
Excel Reference1 |
abcd |
|
SheetName1 |
Colors |
|
Row1 |
1 |
|
Column1 |
1 |
|
Excel Reference2 |
abcd |
|
SheetName2 |
Colors |
|
Row2 |
1 |
|
Column2 |
2 |
Output
Common Error conditions
|
Scenarios |
Error Message |
Debug Information |
|
If the keyword is launched without using Excel Open keyword. |
Conflicting Configuration (-14400)
DESCRIPTION: Some system/application specific settings are preventing this operation. Watch for the applications involved in the current operation. Some of these applications have been wrongly configured. You need to tweak some settings, edit some configuration file, turn a few knobs. The nature and scope of the adjustment will depend on the exact problem faced. |
Excel Reference < abcd > is not opened. |
|
If Blank Data Input Argunments are provided. |
Argument Data Missing (-13200)
DESCRIPTION: A step could not be executed because one or more of the arguments have not been provided a value. Of all the arguments a keyword accepts, some arguments might be compulsory. As opposed to the non-compulsory ones, the compulsory argument must be provided some data. The data may be provided through one of many sources like statically entering, output of a previous step, a global variable etc; but it must not be left blank. |
Argument(s) : (ExcelReference1; SheetName1; Row1; column1; ExcelReference2; SheetName2; Row2; Column2) is/are blank. |
Excel_CreateFile
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
|
Object Input Arguments |
Required? |
Description |
|
Object |
No |
This keyword does not require any object Input Argument. |
|
Data Input Arguments |
Required? |
Description |
|
ExcelPath |
Yes |
Specify the location on which the Excel path has to be created. |
|
SheetName |
No |
Specify the Name of the Sheet existing in the Excel file. |
Output
|
True
|
If the keyword passes successfully |
|
False |
If the keyword fails |
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
|
Scenarios |
Error Message |
Debug Information |
|
If blank data Input Arguments are provided. |
Argument Data Missing (-13200)
DESCRIPTION: A step could not be executed because one or more of the arguments have not been provided a value. Of all the arguments a keyword accepts, some arguments might be compulsory. As opposed to the non-compulsory ones, the compulsory argument must be provided some data. The data may be provided through one of many sources like statically entering, output of a previous step, a global variable etc; but it must not be left blank. |
Argument(s) : ExcelPath; is/are blank. |
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
|
Object Input Arguments |
Required? |
Description |
|
Object |
No |
This keyword does not require any object Input Argument. |
|
Data Input Arguments |
Required? |
Description |
|
ExcelReference |
Yes |
Specify the Reference Name of the Excel file which is used with Excel_Open keyword. |
|
SheetName |
Yes |
Specify the Name of the Sheet whose row has to be deleted. |
|
Row |
Yes |
Specify the Row Number which has to be deleted. |
Output
|
True |
If the keyword passes successfully |
|
False |
If the keyword fails |
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
|
ExcelReference |
abcd |
|
SheetName |
Colors |
|
Row |
5 |
Common Error conditions
|
Scenarios |
Error Message |
Debug Information |
|
If blank data Input Arguments are provided. |
Argument Data Missing (-13200)
DESCRIPTION: A step could not be executed because one or more of the arguments have not been provided a value. Of all the arguments a keyword accepts, some arguments might be compulsory. As opposed to the non-compulsory ones, the compulsory argument must be provided some data. The data may be provided through one of many sources like statically entering, output of a previous step, a global variable etc; but it must not be left blank. |
Argument(s) : (ExcelReference; SheetName;Row) is/are blank. |
|
If the keyword is launched without using Excel Open keyword. |
Conflicting Configuration (-14400)
DESCRIPTION: Some system/application specific settings are preventing this operation. Watch for the applications involved in the current operation. Some of these applications have been wrongly configured. You need to tweak some settings, edit some configuration file, turn a few knobs. The nature and scope of the adjustment will depend on the exact problem faced. |
Excel Reference is not opened. |
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
|
Object Input Arguments |
Required? |
Description |
|
Object |
No |
This keyword does not require any object Input Argument. |
|
Data Input Arguments |
Required? |
Description |
|
Excel Reference1 |
Yes |
Specify the Reference Name of the Excel file which is used with Excel_Open keyword. |
|
Source Sheet |
Yes |
Specify the Name of the Sheet whose Duplicate has to be created |
|
After Target Point |
Specify the Index(after which sheet) of the new duplicate Sheet. |
|
|
New Sheet Name |
Yes |
Specify the Name of the New Sheet |
Output
|
True
|
If the keyword passes successfully |
|
False |
If the keyword fails |
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
|
Excel Reference |
abcd |
|
Source Sheet |
Colors |
|
After Target Point |
1 |
|
New Sheet Name |
Sheet2 |
Output
Common Error conditions
|
Scenarios |
Error Message |
Debug Information |
|
If the keyword is launched without using Excel Open keyword. |
Conflicting Configuration (-14400)
DESCRIPTION: Some system/application specific settings are preventing this operation. Watch for the applications involved in the current operation. Some of these applications have been wrongly configured. You need to tweak some settings, edit some configuration file, turn a few knobs. The nature and scope of the adjustment will depend on the exact problem faced. |
Excel Reference < abcd > is not opened. |
|
If Blank Data Input Argunments are provided. |
Argument Data Missing (-13200)
DESCRIPTION: A step could not be executed because one or more of the arguments have not been provided a value. Of all the arguments a keyword accepts, some arguments might be compulsory. As opposed to the non-compulsory ones, the compulsory argument must be provided some data. The data may be provided through one of many sources like statically entering, output of a previous step, a global variable etc; but it must not be left blank. |
Argument(s) : (ExcelReference; SourceSheet; AfterTargetPoint; NewSheetName) is/are blank. |
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
|
Object Input Arguments |
Required? |
Description |
|
Object |
No |
This keyword does not require any object Input Argument. |
|
Data Input Arguments |
Required? |
Description |
|
ExcelReference |
Yes |
Specify the Reference Name of the Excel file which is used with Excel_Open keyword. |
|
SheetName |
Yes |
Specify the Name of the Sheet |
|
Row |
Yes |
Specify the Row Number of the cell whose value has to be fetched. |
|
Column |
Yes |
Specify the Column Number of the cell whose value has to be fetched. |
Output
|
Returns the Value of the Specified cell |
If the keyword passes successfully |
|
False |
If the keyword fails |
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
|
Excel Reference |
abcd |
|
SheetName |
Colors |
|
Row |
1 |
|
Column |
1 |
Common Error conditions
|
Scenarios |
Error Message |
Debug Information |
|
If the data Input Arguments are not provided |
Argument Data Missing (-13200)
DESCRIPTION: A step could not be executed because one or more of the arguments have not been provided a value. Of all the arguments a keyword accepts, some arguments might be compulsory. As opposed to the non-compulsory ones, the compulsory argument must be provided some data. The data may be provided through one of many sources like statically entering, output of a previous step, a global variable etc; but it must not be left blank. |
Argument(s) : (Column) is/are blank. |
|
If the keyword is launched without using Excel Open keyword. |
Conflicting Configuration (-14400)
DESCRIPTION: Some system/application specific settings are preventing this operation. Watch for the applications involved in the current operation. Some of these applications have been wrongly configured. You need to tweak some settings, edit some configuration file, turn a few knobs. The nature and scope of the adjustment will depend on the exact problem faced. |
Excel Reference < abcd > is not opened. |
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
|
Object Input Arguments |
Required? |
Description |
|
Object |
No |
This keyword does not require any object Input Argument. |
|
Data Input Arguments |
Required? |
Description |
|
ExcelReference |
Yes |
Specify the Reference Name of the Excel file which is used with Excel_Open keyword. |
|
SheetName |
Yes |
Specify the Name of the Sheet which will be used to get the column count. |
|
Row |
Yes |
Specify the Row Number which will be used to get the column count.. |
Output
|
Count of the number of Columns |
If the keyword passes successfully |
|
0 |
If the keyword fails |
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
|
ExcelReference |
abcd |
|
SheetName |
Colors |
|
Row |
4 |
Common Error conditions
|
Scenarios |
Error Message |
Debug Information |
|
If blank data Input Arguments are provided. |
Argument Data Missing (-13200)
DESCRIPTION: A step could not be executed because one or more of the arguments have not been provided a value. Of all the arguments a keyword accepts, some arguments might be compulsory. As opposed to the non-compulsory ones, the compulsory argument must be provided some data. The data may be provided through one of many sources like statically entering, output of a previous step, a global variable etc; but it must not be left blank.
|
Argument(s) : (ExcelReference; SheetName;Row;) is/are blank. |
|
If the keyword is launched without using Excel Open keyword. |
Conflicting Configuration (-14400) DESCRIPTION: Some system/application specific settings are preventing this operation. Watch for the applications involved in the current operation. Some of these applications have been wrongly configured. You need to tweak some settings, edit some configuration file, turn a few knobs. The nature and scope of the adjustment will depend on the exact problem faced. |
Excel Reference is not opened. |
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
|
Object Input Arguments |
Required? |
Description |
|
Object |
No |
This keyword does not require any object Input Argument. |
|
Data Input Arguments |
Required? |
Description |
|
Excel Reference |
Yes |
Specify the Reference Name of the Excel file which is used with Excel_Open keyword. |
|
SheetName |
Yes |
Specify the Name of the Sheet from where the value of a specified column has to be fetched. |
|
Column |
Yes |
Specify the Column Number of the Excel Sheet whose values have to be fetched |
|
Delimiter |
No |
Specify the text/symbol/special characters by which the Column text has to be separated. |
Output
|
Column Values separated by Delimeter
|
If the keyword passes successfully |
|
False |
If the keyword fails |
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
|
ExcelReference |
abcd |
|
SheetName |
Colors |
|
Column |
1 |
|
Delimiter |
# |
Note:
The value of the delimiter is Semicolon(;) by default.
Output
Green#Yellow#Orange#Violet#Royal Blue
Common Error conditions
|
Scenarios |
Error Message |
Debug Information |
|
If blank data Input Arguments are provided. |
Argument Data Missing (-13200)
DESCRIPTION: A step could not be executed because one or more of the arguments have not been provided a value. Of all the arguments a keyword accepts, some arguments might be compulsory. As opposed to the non-compulsory ones, the compulsory argument must be provided some data. The data may be provided through one of many sources like statically entering, output of a previous step, a global variable etc; but it must not be left blank.
|
Argument(s) : (ExcelReference; SheetName;Column) is/are blank.. |
|
If the keyword is launched without using Excel Open keyword. |
Conflicting Configuration (-14400)
DESCRIPTION: Some system/application specific settings are preventing this operation. Watch for the applications involved in the current operation. Some of these applications have been wrongly configured. You need to tweak some settings, edit some configuration file, turn a few knobs. The nature and scope of the adjustment will depend on the exact problem faced. |
Excel Reference is not opened. |
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
|
Object Input Arguments |
Required? |
Description |
|
Object |
No |
This keyword does not require any object Input Argument. |
|
Data Input Arguments |
Required? |
Description |
|
Excel Reference |
Yes |
Specify the Reference Name of the Excel file which is used with Excel_Open keyword. |
|
SheetName |
Yes |
Specify the Name of the Sheet which will be used to get the row count. |
|
Column |
Yes |
Specify the Column Number which will be used to get the row count. |
Output
|
Count of the number of Rows |
If the keyword passes successfully |
|
0 |
If the keyword fails |
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
|
ExcelReference |
abcd |
|
SheetName |
Colors |
|
Column |
1 |
Common Error conditions
|
Scenarios |
Error Message |
Debug Information |
|
If blank data Input Arguments are provided. |
Argument Data Missing (-13200)
DESCRIPTION: A step could not be executed because one or more of the arguments have not been provided a value. Of all the arguments a keyword accepts, some arguments might be compulsory. As opposed to the non-compulsory ones, the compulsory argument must be provided some data. The data may be provided through one of many sources like statically entering, output of a previous step, a global variable etc; but it must not be left blank. |
Argument(s) : (ExcelReference; SheetName;Row;) is/are blank. |
|
If the keyword is launched without using Excel Open keyword. |
Conflicting Configuration (-14400)
DESCRIPTION: Some system/application specific settings are preventing this operation. Watch for the applications involved in the current operation. Some of these applications have been wrongly configured. You need to tweak some settings, edit some configuration file, turn a few knobs. The nature and scope of the adjustment will depend on the exact problem faced. |
Excel Reference < abcd > is not opened. |
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
|
Object Input Arguments |
Required? |
Description |
|
Object |
No |
This keyword does not require any object Input Argument. |
|
Data Input Arguments |
Required? |
Description |
|
ExcelReference |
Yes |
Specify the Reference Name of the Excel file which is used with ExcelOpen keyword. |
|
SheetName |
Yes |
Specify the Name of the Sheet from where the value of a specified Row has to be fetched. |
|
Row |
Yes |
Specify the Row Number of the Excel Sheet whose values have to be fetched |
|
Delimiter |
No |
Specify the text/symbol/special characters by which the Row text has to be separated. |
Output
|
Row Values separated by Delimeter |
If the keyword passes successfully |
|
False |
If an error is there |
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
|
ExcelReference |
abcd |
|
SheetName |
Colors |
|
Row |
2 |
|
Delimiter |
# |
Note:
The value of the delimiter is Semicolon(;) by default.
Output
Yellow#White#Brown
Common Error conditions
|
Scenarios |
Error Message |
Debug Information |
|
If blank data Input Arguments are provided. |
Argument Data Missing (-13200)
DESCRIPTION: A step could not be executed because one or more of the arguments have not been provided a value. Of all the arguments a keyword accepts, some arguments might be compulsory. As opposed to the non-compulsory ones, the compulsory argument must be provided some data. The data may be provided through one of many sources like statically entering, output of a previous step, a global variable etc; but it must not be left blank.
|
Argument(s) : (ExcelReference; SheetName;Row) is/are blank.. |
|
If the keyword is launched without using Excel Open keyword. |
Conflicting Configuration (-14400)
DESCRIPTION: Some system/application specific settings are preventing this operation. Watch for the applications involved in the current operation. Some of these applications have been wrongly configured. You need to tweak some settings, edit some configuration file, turn a few knobs. The nature and scope of the adjustment will depend on the exact problem faced. |
Excel Reference is not opened. |
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
|
Object Input Arguments |
Required? |
Description |
|
Object |
No |
This keyword does not require any object Input Argument. |
|
Data Input Arguments |
Required? |
Description |
|
ExcelReference |
Yes |
Specify the Reference Name of the Excel file which is used with Excel Open keyword. |
|
SheetName |
Yes |
Specify the Name of the Sheet where the Blank rows are to be inserted |
|
NumberofRows |
Yes |
Specify the Number of blank Rows which will be inserted in the Excel Sheet |
|
StartingRow |
Yes |
Specify the starting Row Number of an Excel Sheet after which the blank rows are to be inserted. |
Output
|
True
|
If the keyword passes successfully |
|
False |
If the keyword fails |
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
|
ExcelReference |
abcd |
|
SheetName |
Colors |
|
Number of Rows |
2 |
|
Starting Row |
2 |
This keyword will insert blank rows as follows:
Common Error conditions
|
Scenarios |
Error Message |
Debug Information |
|
If blank data Input Arguments are provided. |
Argument Data Missing (-13200) DESCRIPTION: A step could not be executed because one or more of the arguments have not been provided a value. Of all the arguments a keyword accepts, some arguments might be compulsory. As opposed to the non-compulsory ones, the compulsory argument must be provided some data. The data may be provided through one of many sources like statically entering, output of a previous step, a global variable etc; but it must not be left blank. |
Argument(s) : (ExcelReference; SheetName; NumberOfRows; StartingRow) is/are blank. |
|
If the keyword is used without closing the Excel File on the system. |
Conflicting Configuration (-14400) DESCRIPTION: Some system/application specific settings are preventing this operation. Watch for the applications involved in the current operation. Some of these applications have been wrongly configured. You need to tweak some settings, edit some configuration file, turn a few knobs. The nature and scope of the adjustment will depend on the exact problem faced. |
Close the Excel file abcd in order to modify the data of the file. |
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
|
Object Input Arguments |
Required? |
Description |
|
Object |
No |
This keyword does not require any object Input Argument. |
|
Data Input Arguments |
Required? |
Description |
|
ExcelFile |
Yes |
Specify the Location of the Excel File |
|
ExcelReference |
Yes |
Specify any Reference Name of the Excel file which can be used as a reference for other Excel keywords. |
Output
|
True |
If the keyword passes successfully |
|
False |
If an error is there |
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
|
Scenarios |
Error Message |
Debug Information |
|
If no data Input Arguments are provided |
Argument Data Missing (-13200) DESCRIPTION: A step could not be executed because one or more of the arguments have not been provided a value. Of all the arguments a keyword accepts, some arguments might be compulsory. As opposed to the non-compulsory ones, the compulsory argument must be provided some data. The data may be provided through one of many sources like statically entering, output of a previous step, a global variable etc; but it must not be left blank. |
Argument(s) Excel File; Excel Reference is/are blank. |
|
If Excel File is provided but Excel Reference is blank |
Argument Data Missing (-13200) DESCRIPTION: A step could not be executed because one or more of the arguments have not been provided a value. Of all the arguments a keyword accepts, some arguments might be compulsory. As opposed to the non-compulsory ones, the compulsory argument must be provided some data. The data may be provided through one of many sources like statically entering, output of a previous step, a global variable etc; but it must not be left blank. |
Argument(s) Excel Reference is/are blank. |
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
|
Object Input Arguments |
Required? |
Description |
|
Object |
No |
This keyword does not require any object Input Argument. |
|
Data Input Arguments |
Required? |
Description |
|
ExcelReference |
Yes |
Specify the Reference Name of the Excel file which is used with Excel_Open keyword. |
|
Old SheetName |
Yes |
Specify the Current Name of the Sheet which has to be renamed |
|
New SheetName |
Yes |
Specify the New Name of the Sheet |
Output
|
True |
If the keyword passes successfully |
|
False |
If the keyword fails |
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
|
ExcelReference |
abcd |
|
Old SheetName |
Colors |
|
New SheetName |
My colors |
Common Error conditions
|
Scenarios |
Error Message |
Debug Information |
|
If blank data Input Arguments are provided. |
Argument Data Missing (-13200)
DESCRIPTION: A step could not be executed because one or more of the arguments have not been provided a value. Of all the arguments a keyword accepts, some arguments might be compulsory. As opposed to the non-compulsory ones, the compulsory argument must be provided some data. The data may be provided through one of many sources like statically entering, output of a previous step, a global variable etc; but it must not be left blank. |
Argument(s) : (OldSheetName; NewSheetName) is/are blank. |
|
If the keyword is launched without using Excel Open keyword. |
Conflicting Configuration (-14400)
DESCRIPTION: Some system/application specific settings are preventing this operation. Watch for the applications involved in the current operation. Some of these applications have been wrongly configured. You need to tweak some settings, edit some configuration file, turn a few knobs. The nature and scope of the adjustment will depend on the exact problem faced. |
Excel Reference < abcd > is not opened. |
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
|
Object Input Arguments |
Required? |
Description |
|
Object |
No |
This keyword does not require any object Input Argument. |
|
Data Input Arguments |
Required? |
Description |
|
ExcelReference |
Yes |
Specify the Reference Name of the Excel file which is used with Excel_Open keyword. |
|
SheetName |
Yes |
Specify the Name of the Sheet |
|
Row |
Yes |
Specify the Row Number of the cell for which you want to set the background color |
|
Column |
Yes |
Specify the Column Number of the cell for which you want to set the background color |
|
Background Color |
Yes |
Specify the Color of cell background |
Output
|
True
|
If the keyword passes successfully |
|
False |
If the keyword fails |
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
|
ExcelReference |
abcd |
|
SheetName |
Colors |
|
Row |
1 |
|
Column |
1 |
|
Background Color |
Blue |
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
|
Scenarios |
Error Message |
Debug Information |
|
If the keyword is executed without closing the Excel file on the system. |
Conflicting Configuration (-14400) DESCRIPTION: Some system/application specific settings are preventing this operation. Watch for the applications involved in the current operation. Some of these applications have been wrongly configured. You need to tweak some settings, edit some configuration file, turn a few knobs. The nature and scope of the adjustment will depend on the exact problem faced. |
Close the Excel File < abcd > to modify the data on the file. |
|
If the data Input Arguments are not provided |
Argument Data Missing (-13200) DESCRIPTION: A step could not be executed because one or more of the arguments have not been provided a value. Of all the arguments a keyword accepts, some arguments might be compulsory. As opposed to the non-compulsory ones, the compulsory argument must be provided some data. The data may be provided through one of many sources like statically entering, output of a previous step, a global variable etc; but it must not be left blank. |
Argument(s) : (ExcelReference; SheetName; Row;Column; BackgroundColor) is/are blank. |
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
|
Object Input Arguments |
Required? |
Description |
|
Object |
No |
This keyword does not require any object Input Argument. |
|
Data Input Arguments |
Required? |
Description |
|
ExcelReference |
Yes |
Specify the Reference Name of the Excel file which is used with Excel_Open keyword. |
|
SheetName |
Yes |
Specify the Name of the Sheet |
|
Row |
Yes |
Specify the Row Number of the cell for which you want to set the text color |
|
Column |
Yes |
Specify the Column Number of the cell for which you want to set the text color |
|
Text Color |
Yes |
Specify the Text Color of cell |
Output
|
True |
If the keyword passes successfully |
|
False |
If the keyword fails |
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
|
ExcelReference |
abcd |
|
SheetName |
Colors |
|
Row |
1 |
|
Column |
1 |
|
Text Color |
Blue |
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
|
Scenarios |
Error Message |
Debug Information |
|
If the keyword is executed without closing the Excel file on the system. |
Conflicting Configuration (-14400)
DESCRIPTION: Some system/application specific settings are preventing this operation. Watch for the applications involved in the current operation. Some of these applications have been wrongly configured. You need to tweak some settings, edit some configuration file, turn a few knobs. The nature and scope of the adjustment will depend on the exact problem faced.
|
Close the Excel File < abcd > to modify the data on the file. |
|
If the data Input Arguments are not provided |
Argument Data Missing (-13200)
DESCRIPTION: A step could not be executed because one or more of the arguments have not been provided a value. Of all the arguments a keyword accepts, some arguments might be compulsory. As opposed to the non-compulsory ones, the compulsory argument must be provided some data. The data may be provided through one of many sources like statically entering, output of a previous step, a global variable etc; but it must not be left blank. |
Argument(s) : (ExcelReference; SheetName; Row;Column; TextColor) is/are blank. |
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
|
Object Input Arguments |
Required? |
Description |
|
Object |
No |
This keyword does not require any object Input Argument. |
|
Data Input Arguments |
Required? |
Description |
|
Excel Reference |
Yes |
Specify the Reference Name of the Excel file which is used with Excel_Open keyword. |
|
SheetName |
Yes |
Specify the Name of the Sheet where the value of a specified Row has to be Set. |
|
Row |
Yes |
Specify the Row Number of the Excel Sheet whose values have to be set. |
|
Value |
Yes |
Specify the Values of the row separated by a Delimiter |
|
Delimiter |
No |
Specify the text/symbol/special characters by which the Row text has to be separated. |
Output
|
True |
If the keyword passes successfully |
|
False |
If the keyword fails |
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
|
ExcelReference |
abcd |
|
SheetName |
Colors |
|
Row |
6 |
|
Value |
Green#Yellow#Orange |
|
Delimiter |
# |
Note:
The value of the delimiter is Semicolon(;) by default.
Output
Common Error conditions
|
Scenarios |
Error Message |
Debug Information |
|
If blank data Input Arguments are provided. |
Argument Data Missing (-13200)
DESCRIPTION: A step could not be executed because one or more of the arguments have not been provided a value. Of all the arguments a keyword accepts, some arguments might be compulsory. As opposed to the non-compulsory ones, the compulsory argument must be provided some data. The data may be provided through one of many sources like statically entering, output of a previous step, a global variable etc; but it must not be left blank. |
Argument(s) : (ExcelReference; SheetName;Row;Value) is/are blank. |
|
If the keyword is used without closing the Excel File on the system. |
Conflicting Configuration (-14400)
DESCRIPTION: Some system/application specific settings are preventing this operation. Watch for the applications involved in the current operation. Some of these applications have been wrongly configured. You need to tweak some settings, edit some configuration file, turn a few knobs. The nature and scope of the adjustment will depend on the exact problem faced. |
Close the Excel file abcd in order to modify the data of the file. |
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
|
Object Input Arguments |
Required? |
Description |
|
Object |
No |
This keyword does not require any object Input Argument. |
|
Data Input Arguments |
Required? |
Description |
|
ExcelReference |
Yes |
Specify the Reference Name of the Excel file which is used with ExcelOpen keyword. |
|
SheetName |
Yes |
Specify the Name of the Sheet where the value of a specified Column has to be Set. |
|
Column |
Yes |
Specify the Column Number of the Excel Sheet whose values have to set. |
|
Value |
Yes |
Specify the Values of the Column separated by a Delimiter |
|
Delimiter |
No |
Specify the text/symbol/special characters by which the Column text has to be separated. |
Output
|
True
|
If the keyword passes successfully |
|
False |
If the keyword fails |
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
|
ExcelReference |
abcd |
|
SheetName |
Colors |
|
Column |
4 |
|
Value |
Green#Yellow#Orange#Violet |
|
Delimiter |
# |
Note:
The value of the delimiter is Semicolon(;) by default.
Output
Common Error conditions
|
Scenarios |
Error Message |
Debug Information |
|
If blank data Input Arguments are provided. |
Argument Data Missing (-13200)
DESCRIPTION: A step could not be executed because one or more of the arguments have not been provided a value. Of all the arguments a keyword accepts, some arguments might be compulsory. As opposed to the non-compulsory ones, the compulsory argument must be provided some data. The data may be provided through one of many sources like statically entering, output of a previous step, a global variable etc; but it must not be left blank. |
Argument(s) : (ExcelReference; SheetName; Column;Value) is/are blank. |
|
If the keyword is used without closing the Excel File on the system. |
Conflicting Configuration (-14400)
DESCRIPTION: Some system/application specific settings are preventing this operation. Watch for the applications involved in the current operation. Some of these applications have been wrongly configured. You need to tweak some settings, edit some configuration file, turn a few knobs. The nature and scope of the adjustment will depend on the exact problem faced. |
Close the Excel file abcd in order to modify the data of the file. |
Excel_UtilityPressKeys
This Keyword press keys to the native application window. It takes keys as Data input argument.
Input Arguments
|
Object Input Arguments |
Required? |
Description |
|
Object |
No |
This keyword does not require any object Input Argument. |
|
Data Input Arguments |
Required? |
Description |
|
Keys |
Yes |
Specify the Key Name which has to be pressed. |
Output
|
True |
If the keyword passes successfully |
|
False |
If the keyword fails |
Example
Suppose you want to press Enter key then here is how you will use Utility_PressKeys keyword:
Utility_PressKeys
|
Keys |
{ENTER} |
Note: The key Name is always provided within { } brackets.
Common Error conditions
|
Scenarios |
Error Message |
Debug Information |
|
If the data Input Arguments are not provided |
Argument Data Missing (-13200) DESCRIPTION: A step could not be executed because one or more of the arguments have not been provided a value. Of all the arguments a keyword accepts, some arguments might be compulsory. As opposed to the non-compulsory ones, the compulsory argument must be provided some data. The data may be provided through one of many sources like statically entering, output of a previous step, a global variable etc; but it must not be left blank. |
Argument(s) : (Keys) is/are blank. |
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
|
Object Input Arguments |
Required? |
Description |
|
Object |
No |
This keyword does not require any object Input Argument. |
|
Data Input Arguments |
Required? |
Description |
|
ExcelReference |
Yes |
Specify the Reference Name of the Excel file which is used with Excel-Open keyword. |
|
SheetName |
Yes |
Specify the Name of the Sheet whose cell value has to be set. |
|
Text |
Yes |
Specify the Text/Value to be set.l |
|
Row |
Yes |
Specify the Row Number whose Cell value has to be set |
|
Column |
Yes |
Specify the Column Number whose Cell value has to be set |
Output
|
True |
If the keyword passes successfully |
|
False |
If the keyword fails |
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
|
ExcelReference |
abcd |
|
SheetName |
Colors |
|
Text |
Pink |
|
Row |
4 |
|
Column |
1 |
Common Error conditions
|
Scenarios |
Error Message |
Debug Information |
|
If blank data Input Arguments are provided. |
Argument Data Missing (-13200) DESCRIPTION: A step could not be executed because one or more of the arguments have not been provided a value. Of all the arguments a keyword accepts, some arguments might be compulsory. As opposed to the non-compulsory ones, the compulsory argument must be provided some data. The data may be provided through one of many sources like statically entering, output of a previous step, a global variable etc; but it must not be left blank. |
Argument(s) : (ExcelReference; SheetName;Text; Row;Column) is/are blank. |
|
If the keyword is launched without using Excel Open keyword. |
Conflicting Configuration (-14400) DESCRIPTION: Some system/application specific settings are preventing this operation. Watch for the applications involved in the current operation. Some of these applications have been wrongly configured. You need to tweak some settings, edit some configuration file, turn a few knobs. The nature and scope of the adjustment will depend on the exact problem faced. |
Excel Reference is not opened. |
