Utility Keywords

How to use Keywords?


Keywords are used by calling them in a test step and adding the input and expected output data values. If you want to capture the dynamic objects, you can also add properties of the object in the test object column. Let's understand this with an example of using the Excel_VerifyCellValue keyword.


1. Excel_VerifyCellValue



This keyword verifies content available inside any specified cell of an Excel file. It is mostly used in situations where you have to verify the value available within any specified cell.

 

It takes ExcelReference, SheetName, Row, Column, and Expected Value as references for input and shares the stored value.


For example, to verify the content inside an Excel file, we can use the following steps:-



1. Add a new step in your test case by clicking the + icon at the top. Search Excel_VerifyCellValue and click on the search result to add it to the new test step.

 

2. Click the Three dots icon in the input data column of the step to open the input data window for the keyword.


3. Add the input data related to the Excel file as shown below. 




Note: We have illustrated the requirement of the Test Object, Input Data, and corresponding Output data values in the tables following this image. These values are filled as per the requirement of the keyword used in the test case as shown in the image below. We have given similar tables for each keyword for illustration. 

In this Keyword, there was no requirement to add a Test Object's properties, hence, we have mentioned it is not required.


Test Object 


Test Object Required

Description

None

Not Required


Input Data

 Input Data Required

 Description 

 

ExcelReference

 Specify the Reference Name of the Excel file that is used with the Excel_Open keyword. 

                     SheetName

Specify the Name of the Sheet 

Row

 Specify the Row Number of the cell whose value has to be fetched.

 columnNumber

 Specify the Column Number of the cell whose value has to be fetched.

Expected Value

Specify the Expected Value of the cell


Output Data

Condition

Output value

If the keyword passes successfully

True

if there is an error

False



Common Error conditions

Scenarios

Error Message

Debug Information

If the data Input Arguments are not provided  

Argument Data Missing (-13200) 

DESCRIPTION: 

A step can't proceed without values for mandatory arguments. Unlike optional ones, compulsory arguments must be filled with data, which can come from a static entry, a previous step's output, or a global variable. Leaving them empty is not allowed. 

Argument(s) : (Column) is/are blank.

If an 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 : 


Now let's go through the list of various keywords to understand their utility. 


2. Excel_VerifyColumnCount


This keyword verifies the number of Columns corresponding to the specified Row Number of an Excel file.


Note: The Excel_Open Keyword is always used before this keyword.


Example


ExcelReference

abcd

SheetName

Colors

Row

1

Expected Value

3

 

Test Object 


Test Object Required

Description

None

Not Required


Input Data

 Input Data Required

 Description 

 

ExcelReference

 Specify the Reference Name of the Excel file that is used with the Excel_Open keyword. 

                     SheetName

Specify the Name of the Sheet whose  number of Columns has to be Verified

Row

 Specify the Row Number which will be used to Verify the Column count.

Expected Value

Specify the Expected count of columns corresponding to the specified Row Number of an Excel file


Output Data

Condition

Output value

If the keyword passes successfully

True

if there is an error

False



 Error conditions


Scenarios

Error Message

Debug Information

If blank data Input Arguments are provided.  

Argument Data Missing (-13200) 

 

DESCRIPTION: 

A step can't proceed without values for mandatory arguments. Unlike optional ones, compulsory arguments must be filled with data, which can come from a static entry, a previous step's output, or a global variable. Leaving them empty is not allowed. 

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 files, turn a few knobs. The nature and scope of the adjustment will depend on the exact problem faced.

Excel Reference    is not opened.




3. Excel_VerifyRowCount


This keyword verifies the number of rows corresponding to the specified Column Number of an Excel file.

Note: The Excel_Open Keyword is always used before this keyword.


Example 


ExcelReference

abcd

SheetName

Colors

Column

3

Expected Value

1


Test Object 


Test Object Required

Description

None

Not Required


Input Data

 Input Data Required

 Description 

 

ExcelReference

 Specify the Reference Name of the Excel file which is used with Excel_Open keyword. 

                     SheetName

Specify the Name of the Sheet whose  number of Columns has to be Verified

Column

 Specify the Column Number which will be used to Verify the Column count.

Expected Value

Specify the Expected count of columns corresponding to the specified Row Number of an Excel file


Output Data

Condition

Output value

If the keyword passes successfully

True

if there is an error

False





 

Error conditions


Scenarios

Error Message

Debug Information

If blank data Input Arguments are provided.  

Argument Data Missing (-13200) 

 

DESCRIPTION: 

A step can't proceed without values for mandatory arguments. Unlike optional ones, compulsory arguments must be filled with data, which can come from static entry, a previous step's output, or a global variable. Leaving them empty is not allowed. 

Argument(s) : (ExcelReference;

SheetName;Column) is/are blank.

If the keyword is launched without using Excel Open the keyword.

Conflicting Configuration (-14400) 

 

DESCRIPTION: 

System or application settings are impeding the operation. Identify and correct misconfigurations in involved applications, adjusting settings, editing configuration files, or turning knobs based on the specific issue encountered. 

Excel Reference is not opened.


4. Excel_ClearCellValue

This keyword clears the value of a cell in an Excel file based on the data input arguments provided.

NoteExcel_Open Keyword is always used before this keyword.



Example


Example


ExcelReference

abcd

SheetName

Colors

StartingRow

300

Starting Column


30

Ending Row

330

Ending Column

30


Test Object 


Test Object Required

Description

None

Not Required


Input Data


Input Data Required

Description

ExcelReference

Specify the Reference Name of the Excel file that is used with the ExcelOpen keyword. 

SheetName

Specify the Name of the Sheet whose Cell Value has to be cleared 

StartingRow

Specify the Starting Row from where the values/data have to be deleted.

StartingColumn

Specify the Starting Column from where the values/data have to be deleted.

EndingRow

Specify the Ending Row till where the values/data have to be deleted.

EndingColumn

Specify the Ending Column till where the values/data have to be deleted.


Output Data

Condition

Output value

If the keyword passes successfully

True

if there is an error

False


 

Error conditions


Scenarios

Error Message

Debug Information

If the keyword is executed without closing the Excel file on the system.  

Conflicting Configuration (-14400) 

 

DESCRIPTION: 

System or application settings are impeding the operation. Identify and correct misconfigurations in involved applications, adjusting settings, editing configuration files, or turning knobs based on the specific issue encountered. 

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: 

System or application settings are impeding the operation. Identify and correct misconfigurations in involved applications, adjusting settings, editing configuration files, or turning knobs based on the specific issue encountered. 

Excel Reference    is not opened.


5. Excel_ClearColumn

This keyword clears column (s) of the Excel file based on the data input argument provided.

NoteExcel_Open Keyword is always used prior to this keyword.


Test Object 


Test Object Required

Description

None

Not Required


Input Data


Data Input Arguments

Description

Excel Reference

Specify the Reference Name of the Excel file which is used with Excel_Open keyword. 

SheetName

Specify the Name of the Sheet whose Column Values has to be cleared 

Starting Column Number

Specify the Starting Column from where the values/data has to be cleared.

Number of Columns

Specify the Number of Columns whose value has to be cleared


Output Data

Condition

Output value

If the keyword passes successfully

True

if there is an error

False



Error conditions


Scenarios

Error Message

Debug Information

If blank data Input Arguments are provided.  

Argument Data Missing (-13200) 

 

DESCRIPTION: 

Argument(s) : (SheetName;

StartingColumn

Number;

NumberOf

Columns) is/are blank.

If the keyword is launched without using Excel Open keyword.

Conflicting Configuration (-14400) 

DESCRIPTION: 

System or application settings are impeding the operation. Identify and correct misconfigurations in involved applications, adjusting settings, editing configuration files, or turning knobs based on the specific issue encountered. 

Excel Reference 

   is not opened.


6. Excel_ClearRows

This keyword clears Row(s) of Excel file based on the data input argument provided.

NoteExcel_Open Keyword is always used prior to this keyword.


Example :- 


Excel_ClearRows

ExcelReference

abcd 

SheetName

Colors 

Starting Row Number

4

Number of Rows

2


 

Test Object 


Test Object Required

Description

None

Not Required


Input Data


 

Input Data Required

Description

ExcelReference

Specify the Reference Name of the Excel file that is used with the Excel_Open keyword. 

SheetName

Specify the Name of the Sheet whose Column Values have to be cleared 

Starting Row Number

Specify the Starting Row from where the values/data have to be cleared.

Number of Rows

Specify the Number of Rows whose value has to be cleared.

 

Output Data

Condition

Output value

If the keyword passes successfully

True

if there is an error

False



Error conditions


Scenarios

Error Message

Debug Information

If blank data Input Arguments are provided.  

Argument Data Missing (-13200) 

 

DESCRIPTION: 

A step can't proceed without values for mandatory arguments. Unlike optional ones, compulsory arguments must be filled with data, which can come from static entry, a previous step's output, or a global variable. Leaving them empty is not allowed. 

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.


7. Excel_Close

This keyword helps close the currently opened Excel reference File. It takes Excel Reference as Data Input Arguments.

NoteExcel_Open Keyword is always used prior to this keyword.

Example



ExcelReference

abcd 



Test Object 


Test Object Required

Description

None

Not Required


Input Data

 

Input Data Required

Description

ExcelReference

Specify the Reference Name of the Excel file which is used with ExcelOpen keyword. 

 

Output Data

Condition

Output value

If the keyword passes successfully

True

if there is an error

False



Error conditions


Scenarios

Error Message

Debug Information

If the data Input Arguments are not provided  

Argument Data Missing (-13200) 

 

DESCRIPTION: 

A step can't proceed without values for mandatory arguments. Unlike optional ones, compulsory arguments must be filled with data, which can come from static entry, a previous step's output, or a global variable. Leaving them empty is not allowed. 

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   



8. Excel_CloseAll

This keyword closes all the opened Excel File. 

NoteExcel_Open Keyword is always used prior to this keyword.



Example

Suppose you want to close all the opened Excel files saved on your system then you can use Excel_CloseAll keyword.


Test Object 


Test Object Required

Description

None

Not Required


Input Data

 

Data Input Required?

Description

No

This keyword does not require any Data Input Argument.

 

Output Data

Condition

Output value

If the keyword passes successfully

True

if there is an error

False



Error conditions

There are no error conditions for this keyword.




9. Excel_CompareCellValue

This Keyword compares the values of two specified cells within the same Excel file or two different Excel files based on the Data Input Arguments provided.

 

NoteExcel_Open Keyword is always used before this keyword.


Example:-

Excel_CompareCellValue

Excel Reference1

abcd

SheetName1

Colors

Row1

1

Column1

1

Excel Reference2

abcd

SheetName2

Colors

Row2

1

Column2

2


 


Test Object 


Test Object Required

Description

None

Not Required


Input Data  

Data Input Arguments

Description

ExcelReference1

Specify the Reference Name of the Excel file which is used with Excel_Open keyword. 

SheetName1

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

Specify the Column Number of the  Excel Sheet whose Cell value have to be compared

Excel Reference2

Specify the Reference Name of the Excel file which is used with Excel_Open keyword. 

SheetName2

Specify the Name of the Sheet whose Cell Value has to be compared.

Row2

Specify the other Row Number of the  Excel Sheet whose Cell Value has to be compared.

Column2

Specify the other Column Number of the  Excel Sheet whose Cell value have to be compared

 

Output Data

Condition

Output value

If the keyword passes successfully

True

if there is an error

False



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 can't proceed without values for mandatory arguments. Unlike optional ones, compulsory arguments must be filled with data, which can come from static entry, a previous step's output, or a global variable. Leaving them empty is not allowed. 

Argument(s) : (ExcelReference1;

SheetName1

;Row1;Column1;Excel

Reference2;

SheetName2;Row2;

Column2) is/are blank.



10. Excel_CompareColumns

This Keyword compares the values of two specified Columns within the same Excel file or two different Excel files based on the Data Input Arguments provided.

NoteExcel_Open Keyword is always used before this keyword.


Example:- 


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.




Test Object 


Test Object Required

Description

None

Not Required


Input Data

 

Input Data Required

Description

Object

This keyword does not require any object Input Argument.

Data Input Arguments

Description

ExcelReference1

Specify the Reference Name of the Excel file which is used with Excel_Open keyword. 

SheetName1

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

Specify the Reference Name of the Excel file which is used with Excel_Open keyword. 

SheetName2

Specify the Name of the Sheet whose Column Values has to be compared.

Column2

Specify the other Column Number of the  Excel Sheet whose Column Value has to be compared.

Delimiter

Specify the text/symbol/special characters by which the Column text has to be separated.


Output Data

Condition

Output value

If the keyword passes successfully

True

if there is an error

False



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 can't proceed without values for mandatory arguments. Unlike optional ones, compulsory arguments must be filled with data, which can come from static entry, a previous step's output, or a global variable. Leaving them empty is not allowed. 

Argument(s) : (ExcelReference1;Sheet

Name1;

Column1;Excel

Reference2;Sheet

Name2;

Column2) is/are blank.


11. Excel_CompareRows

This Keyword compares the values of two specified Rows within the same excel file or two different Excel files based on the Data Input Arguments provided.


NoteExcel_Open Keyword is always used prior to this keyword.


Example :-


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.

Test Object 


Test Object Required

Description

None

Not Required



Input Data


Input Data Required

Description

ExcelReference1

Specify the Reference Name of the Excel file which is used with Excel_Open keyword. 

SheetName1

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

Specify the Reference Name of the Excel file which is used with Excel_Open keyword. 

SheetName2

Specify the Name of the Sheet whose Row Values has to be compared.

Row2

Specify the other Row Number of the  Excel Sheet whose Row Value has to be compared.

Delimiter

Specify the text/symbol/special characters by which the Row text has to be separated.

 

Output Data


Condition

Output value

If the keyword passes successfully

True

if there is an error

False



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 can't proceed without values for mandatory arguments. Unlike optional ones, compulsory arguments must be filled with data, which can come from static entry, a previous step's output, or a global variable. Leaving them empty is not allowed. 

Argument(s) : (ExcelReference1;

SheetName1;Row1;

Column1;Excel

Reference2

;SheetName2;Row2

;Column2) is/are blank.


12. Excel_CompareSheet

This keyword is used to compare two Excel sheets with in single excel file or two different excel file based on data input arguments provided.

NoteExcel_Open Keyword is always used prior to this keyword.


Example 



Excel Reference1

abcd

SheetName1

Colors

Excel Reference2

Mysheet

SheetName2

Stars 

Delimiter

 


 

Test Object 

Test Object Required

Description

None

Not Required

 

Input Data 


Data Data Required

Description

ExcelReference1

Specify the Reference Name of the Excel file that is used with the Excel_Open keyword. 

SheetName1

Specify the Name of the Sheet which has to be compared.

ExcelReference2

Specify the Reference Name of the Excel file that is used with the Excel_Open keyword.

SheetName2

Specify the Name of the other Sheet which has to be compared

Delimiter

Specify the text/symbol/special characters by which the text of the two sheets are separated.


Output Data


Condition

Output value

If the keyword passes successfully

True

if there is an error

False



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 can't proceed without values for mandatory arguments. Unlike optional ones, compulsory arguments must be filled with data, which can come from static entry, a previous step's output, or a global variable. Leaving them empty is not allowed. 

Argument(s) : (ExcelReference1;

SheetName1;

ExcelReference2;

SheetName2) is/are blank.



13. Excel_CopyAndPasteCellValue

This keyword is used to copy and paste particular cell value (s) within single excel sheet or within two different excel sheet or within 2 different excel sheets of 2 different excel files based on the Data Input Arguments provided.

NoteExcel_Open Keyword is always used prior to this keyword. The Excel File must be closed before using this Keyword.


Example :- 


Excel_CopyAndPasteCellValue

Excel Reference1

abcd

SheetName1

Colors

Row1

1

Column1

1

Excel Reference2

abcd

SheetName2

Colors

Row2

1

Column2

2




Test Object 

Test Object Required

Description

None

Not Required


Input Data

 

Input Data Required

Description

ExcelReference1

Specify the Reference Name of the Excel file which is used with Excel_Open keyword. 

SheetName1

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

Specify the Column Number of the  Excel Sheet whose Cell value have to be Copied

Excel Reference2

Specify the Reference Name of the Excel file which is used with Excel_Open keyword. 

SheetName2

Specify the Name of the Sheet in which the Cell Value of the copied cell has to be Pasted.

Row2

Specify the other Row Number of the  Excel Sheet where the Cell Value of the copied cell has to be Pasted.

Column2

Specify the other Column Number of the  Excel Sheet where the Cell Value of the copied cell has to be Pasted.

 

Output Data


Condition

Output value

If the keyword passes successfully

True

if there is an error

False



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 can't proceed without values for mandatory arguments. Unlike optional ones, compulsory arguments must be filled with data, which can come from static entry, a previous step's output, or a global variable. Leaving them empty is not allowed. 

Argument(s) : (ExcelReference1;

SheetName1;

Row1;

column1;

ExcelReference2;

SheetName2;

Row2;

Column2) is/are blank.


14. Excel_CreateFile

This keyword creates a new Excel file, it supports only .xlsx and xls format file. It takes File path and Sheet name (optional) as data input arguments.

Note: Specify the Excel Path of the file with .xlsx or xls Extension

 

Test Object 

Test Object Required

Description

None

Not Required


Input Data

 

Input Data Required

Description

ExcelPath

Specify the location on which the Excel path has to be created.

SheetName

Specify the Name of the Sheet existing in the Excel file.

 

Output Data


Condition

Output value

If the keyword passes successfully

True

if there is an error

False



Error conditions


Scenarios

Error Message

Debug Information

If blank data Input Arguments are provided.  

Argument Data Missing (-13200) 

 

DESCRIPTION: 

Argument(s) : ExcelPath; is/are blank.


15. Excel_DeleteRow

This keyword is used to delete row(s) from the particular Excel sheet based on the data input arguments provided.

NoteExcel_Open Keyword is always used prior to this keyword.


Example :- 


Excel_DeleteRow

ExcelReference

abcd

SheetName

Colors 

Row

5



Test Object 

Test Object Required

Description

None

Not Required


Input Data

 

Input Data Required

Description

ExcelReference

Specify the Reference Name of the Excel file which is used with Excel_Open keyword. 

SheetName

Specify the Name of the Sheet whose row has to be deleted.

Row

Specify the Row Number which has to be deleted.


Output Data


Condition

Output value

If the keyword passes successfully

True

if there is an error

False


 

Error conditions


Scenarios

Error Message

Debug Information

If blank data Input Arguments are provided.  

Argument Data Missing (-13200) 

 

DESCRIPTION: 

A step can't proceed without values for mandatory arguments. Unlike optional ones, compulsory arguments must be filled with data, which can come from static entry, a previous step's output, or a global variable. Leaving them empty is not allowed. 

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.


16. Excel_DuplicateSheet

This keyword is used to create a duplicate copy of an Excel sheet within an Excel File based on the data input arguments provided.

NoteExcel_Open Keyword is always used prior 

to this keyword.The Excel File must be closed before using this Keyword.


Example 


Suppose you want to Create a Duplicate Sheet of an Excel Sheet within an Excel File saved on your system then here is how you will use Excel_DuplicateSheet keyword:

Excel_DuplicateSheet

Excel Reference

abcd

Source Sheet

Colors

After Target Point

1

New Sheet Name

Sheet2 



Test Object 

Test Object Required

Description

None

Not Required


Input Data

 

Input Data Required

Description

Excel Reference1

Specify the Reference Name of the Excel file which is used with Excel_Open keyword. 

Source Sheet

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

Specify the Name of the New Sheet 


Output Data


Condition

Output value

If the keyword passes successfully

True

if there is an error

False



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.


17. Excel_GetCellValue

This keyword will fetch the value from a specified cell of an Excel File based on the Data Input Arguments provided.

NoteExcel_Open Keyword is always used prior to this keyword.


Example 


Excel_GetcellValue

Excel Reference

abcd 

SheetName

Colors 

Row

1

Column

1


 

Test Object 

Test Object Required

Description

None

Not Required



Input Data

 

Input Data Required

Description

ExcelReference

Specify the Reference Name of the Excel file which is used with Excel_Open keyword. 

SheetName

Specify the Name of the Sheet 

Row

Specify the Row Number of the cell whose value has to be fetched.

Column

Specify the Column Number of the cell whose value has to be fetched.


Output Data


Condition

Output value

If the keyword passes successfully

Returns the Value of the Specified cell

If the keyword fails 

False


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.


18. Excel_GetColumnCount

This Keyword Returns the number of columns in the specified Excel file. This keyword is used in a situation where user wants the  Column Count of an Excel file with the help of Row Number.

NoteExcel_Open Keyword is always used prior to this keyword.


Example 


Excel_GetColumnCount

ExcelReference

abcd

SheetName

Colors 

Row

4




Test Object


Object Input  Required

Description