1. Home
  2. Opkey Help
  3. 25. Opkey Keyword Documentation
  4. 25.7 Excel Keywords

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

1.jpg

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

1.jpg

In the given screenshot, suppose you want to verify the number of rows corresponding to the specified Column Number of an Excel file saved  on your system then here is how you will use Excel_VerifyRowCount keyword:

Excel_VerifyRowCount

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

1.jpg

In the given screenshot, suppose you want to clear the Column values of the highlighted Column cells of the Excel File saved on your system then here is how you will use Excel_ClearColumn keyword:

Excel_ClearColumn

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

1.jpg

In the given screenshot, suppose you want to clear the Row values of the highlighted row cells of the Excel File saved on your system then here is how you will use Excel_ClearRows keyword:

Excel_ClearRows

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

1.jpg

In the given screenshot, suppose you want to compares the values of the  highlighted cells of an Excel file saved  on your system then here is how you will use Excel_CompareCellValue keyword:

Excel_CompareCellValue

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

1.jpg

In the given screenshot, suppose you want to compares the values of the  highlighted columns of an Excel file saved  on your system then here is how you will use Excel_CompareColumns keyword:

Excel_CompareColumns

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

1.jpg

In the given screenshot, suppose you want to compares the values of the  highlighted rows of an Excel file saved  on your system then here is how you will use Excel_CompareRows keyword:

Excel_CompareRows

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

1.jpg

In the given screenshot, suppose you want to copy the value of the highlighted cell and then paste it on another cell of an Excel Sheet then here is how you will use Excel_CopyAndPasteCellValue keyword:

Excel_CopyAndPasteCellValue

Excel Reference1

abcd

SheetName1

Colors

Row1

1

Column1

1

Excel Reference2

abcd

SheetName2

Colors

Row2

1

Column2

2

Output

1.jpg

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

1.jpg

In the given screenshot, suppose you want to Delete the highlighted row of an  Excel File saved  on your system then here is how you will use Excel_DeleteRow keyword:

Excel_DeleteRow

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

1.jpg

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

1.jpg

In the given screenshot, suppose you want to Get the number of columns  of an  Excel File saved  on your system then here is how you will use Excel_GetColumnCount keyword:

Excel_GetColumnCount

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

1.jpg

In the given screenshot, suppose you want to fetch the values of the highlighted column separated by Delimiter of an Excel file saved  on your system then here is how you will use Excel_GetColumnValue keyword:

Excel_GetColumnValue

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

1.jpg

In the given screenshot, suppose you want to Get the number of rows of an  Excel File saved  on your system then here is how you will use Excel_GetRowCount keyword:

Excel_GetRowCount

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

1.jpg

In the given screenshot, suppose you want to fetch the values of the highlighted row separated by Delimiter of an Excel file saved  on your system then here is how you will use Excel_GetRowValue keyword:

Excel_GetRowValue

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

1.jpg

In the given screenshot, suppose you want to Insert 2 blank rows after row number 2 in an Excel Sheet of an Excel file saved  on your system then here is how you will use Excel_InsertBlankRows keyword:

Excel_InsertBlankRows

ExcelReference

abcd

SheetName

Colors

Number of Rows

2

Starting Row

2

This keyword will insert blank rows as follows:

1.jpg

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

1.jpg

In the given screenshot, suppose you want to change the name of the highlighted sheet of the Excel File saved on your system then here is how you will use Excel_RenameSheet  keyword:

Excel_RenameSheet

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

1.jpg

In the given screenshot, suppose you want to set values in the highlighted row of an Excel file saved  on your system then here is how you will use Excel_SetRowValue keyword:

Excel_SetRowValue

ExcelReference

abcd

SheetName

Colors

Row

6

Value

Green#Yellow#Orange

Delimiter

#

Note:

The value of the delimiter is Semicolon(;) by default.

Output

1.jpg

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

1.jpg

In the given screenshot, suppose you want to set values in the highlighted Column of an Excel file saved  on your system then here is how you will use Excel_SetColumnValue keyword:

Excel_SetColumnValue

ExcelReference

abcd

SheetName

Colors

Column

4

Value

Green#Yellow#Orange#Violet

Delimiter

#

Note:

The value of the delimiter is Semicolon(;) by default.

Output

1.jpg

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

1.jpg

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

1.jpg

In the given screenshot, suppose you want to set the value of the highlighted Cell of an  Excel File saved  on your system then here is how you will use Excel_SetCellValue keyword:

Excel_SetCellValue

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.

Was this article helpful to you? Yes No