Page Comparison

Browser Type

Enter the browser name in which you want to open the URL.

Parameters can be as follows:

• IE: This will open URL in Internet Explorer.

• Firefox: This will open URL in Mozilla Firefox.

• Chrome: This will open URL in Google Chrome.

Yes

String

URL

Enter the URL to be opened.

Yes

String

Browser version

Enter the major and minor version of the browser installed on testing machine. For example, if browser version is 54.9.0.3323, then enter only 54.9.

No

String

Path

This parameter is applicable only when using Google Chrome browser.

Enter the absolute path of the chrome.exe from the Google Chrome installed location.

No

String

DriverString

The DriverString is a combination of driver and database details which helps automation tool to connect to the database. You must provide details in specified format as follows:

DRIVER=~{<DriverName>~};Server=<ServerIP/HostName,PortNumber>; Database=<DBName>;UID=<DBUsername>;PWD=<DBPassword>

Yes

String

Query

The query that needs to be executed.

Yes

String

Key

Enter the key under which you want to store the results. Key value van be retrieved using the key name.

Yes

String

filePath

Enter absolute path to the Excel file from which you want to get and store the value.

Yes

String

sheetName

Enter the sheet name from the Excel file from which value is to be stored.

Yes

String

rowNumber

Enter the row number of the cell from which you want to store the value.

Yes

String

columnID

Enter the column ID or column name from which you want to store the value in the following format.
- Column ID either can be an index number of the column or column header (mentioned at the top of each column, starts from the letter A). For example: to specify 2nd column, use col::2 or col::B.
- Column name: Enter the name of the column from which you want to store the value. This name is provided by the user while adding data.

Yes

String

Key

Enter the key name under which you want to store the value. The key value can be retrieved using the key name.

Yes

String

filePath

Enter absolute path to the Excel file.

Yes

String

sheetname

Enter the sheet name from the Excel file in which you want to add the values.

Yes

String

RowNumber

Enter the row number in which you want to add the value.

Yes

String

ColumnID

Enter the column ID or column name in which you want to add the value in the following format.
- Column ID either can be an index number of the column or column header (mentioned at the top of each column, starts from the letter A). For example: to specify 2nd column, use col::2 or col::B.
- Column name: Enter the name of the column from which you want to store the value. This name is provided by the user while adding data.

Yes

String

Data

This is the data to be added to the specified Excel row. In case you are statically creating an array, values should be separated by caret (^).

Yes

Array

Overwrite

Specify whether you want to overwrite the existing data or you want to add another row to add this data. Values for this parameter can be as follows:

• Enter Previous to add a new row before the row specified above.

• Enter Next to add a new row after the row specified above.

• Enter Current to overwrite new values over the existing set of values.

No

String

filePath

Enter absolute path to the Excel file.

Yes

String

sheetname

Enter the sheet name from the Excel file in which you want to add the values.

Yes

String

RowNumber

Enter the row number in which you want to add the value.

Yes

String

ColumnID

Enter the column ID or column name in which you want to add the value in the following format.
- Column ID either can be an index number of the column or column header (mentioned at the top of each column, starts from the letter A). For example: To specify the 2nd column, use col::2 or col::B.
- Column Name: Enter the name of the column from which you want to store the value. This name is provided by the user while adding data.

Yes

String

Data

You need to add the data in the specified Excel row. In case you are statically creating an array, values should be separated by caret (^).

Yes

Array

Overwrite

Specify whether you want to overwrite the existing data or you want to add another row to add this data. Values for this parameter can be as follows:

• Enter Previous to add a new column before the column specified above.

• Enter Next to add a new column after the column specified above.

• Enter Current to overwrite new values over the existing set of values.

No

String

filePath

Enter absolute path to the Excel file.

Yes

String

sheetname

Enter the sheet name from the Excel file from which you want to store the column count.

Yes

String

ignoreBlankColumn

Specify whether you want to ignore the blank columns while calculation.

• To ignore blank columns, use True.

• To consider even blank columns, use False.

No

String

Key

Enter the key name under which you want to store the value.

Yes

String

Key

Enter the key name under which you want to store the value.

                       Yes

String

filePath

Enter the absolute path to the Excel file.

Yes

String

sheetname

Enter the sheet name from the Excel file from which you want to store the row count.

Yes

String

ignoreBlankRows

Specify whether you want to ignore the blank rows while calculation.

• To ignore blank rows, use True.

• To consider even blank rows, use False.

No

String

filePath

Enter absolute path to the Excel file.

Yes

String

sheetname

Enter the sheet name from the Excel file in which you want to check for the data.

Yes

String

ColumnNumber

Enter the column ID or column name in which you want to add the value in the following format.
- Column ID either can be an index number of the column or column header (mentioned at the top of each column, starts from the letter A). For example: to specify 2nd column, use col::2 or col::B
- Column name: Enter the name of the column from which you want to store the value. This name is provided by the user while adding data.

Yes

String

Data

You need to add the data in the specified Excel row. In case you are statically creating an array, values should be separated by caret (^).

Yes

String

Key

Enter the key name under which you want to store the occurrence.

Yes

String

FilePath

Enter the absolute path to the file from which you want to store data.

Yes

String

RowNumber

Enter the row number from which you want to get and store the data.

Yes

String

Key

Enter the key name in which you want to store the data.  

Yes

String

FilePath

Enter the absolute path to the file in which you want to verify data.

Yes

String

Data

Enter the data which you want to verify in the file.

Yes

String

CaseSensitive

Enter whether you want to consider case-sensitivity when verifying data. Value for this parameter can be True or False.

• Set True for case-sensitive comparison.

• Set False for case-insensitive comparison. 

Yes

String