Macro lookup error: excerpt "VerifyExistence" was not found on page "WebButton Actions" (with ID 221643190) in space "QFWM".

If you're experiencing issues please see our Troubleshooting Guide.

Macro lookup error: excerpt "VerifyVisibility" was not found on page "WebButton Actions" (with ID 221643190) in space "QFWM".

If you're experiencing issues please see our Troubleshooting Guide.

StoreColumnCount

This action stores the column count of the specified table under the specified key.

Input Parameters:

Parameter Name	Parameter Description	Mandatory	Data Type
key	Enter the variable name to store table's column count.	Yes	String
row	Enter the row number whose column count you want to store.	Yes	String

Example:
StoreColumnCount "key" "2"

StoreRowCount

This action stores the row count of the specified table under the specified key.

Input Parameters:

Parameter Name	Parameter Description	Mandatory	Data Type
key	Enter the key name under which you want to store table's row count.	Yes	String

Example:
StoreRowCount "Key"

Parameter Name	Parameter Description	Mandatory	Data Type
Link	Enter the URL to be clicked.	Yes	String
Row	Enter the row number of the cell in which the link is present. Row number starts at 1	Yes	String
Column	Enter the column number of the cell in which the link is present. Column number starts at 1	Yes	String

Example:
ClickLinkAtCell "http://www.google.com" "2" "3"

If Link is an empty data ("" or $NULL$), and there are multiple links in the cell, then the first link in the cell will be clicked. If there is only one link in the cell, then the link will be clicked. However, if there is no link available in the cell, the action will fail with an error message that no link is available in the cell.

StoreRowNoOfCellText

This action stores the row number of the cell having the specified data in a specified column. This comparison is case-sensitive. When multiple cells in the column specified contain the expected data, then the first row number is stored under the specified key. This is also applicable for tables where each row in the table has different number of columns.

Input Parameters:

Parameter Name	Parameter Description	Mandatory	Data Type
Key	The variable in which the row number is to be stored.	Yes	String
cellText	Cell data to be searched for in the table.	Yes	String
Column	Column number of the cell data to be searched for. Column number starts at 1.	Yes	String

Example:
StoreRowNoOfCellText "key" "Testing" "2"

Macro lookup error: excerpt "Click" was not found on page "WebButton Actions" (with ID 221643190) in space "QFWM".

If you're experiencing issues please see our Troubleshooting Guide.

Macro lookup error: excerpt "StorePropertyValue" was not found on page "WebButton Actions" (with ID 221643190) in space "QFWM".

If you're experiencing issues please see our Troubleshooting Guide.

ClickImageInCell

This action clicks the image from the specified cell.

Input Parameters:

Parameter Name	Parameter Description	Mandatory	Data Type
altorindex	Enter any of the attribute of the image. This can be alt or title. This parameter can also be an index. Index starts from 1. Following will be the preference in which the action will assume the incoming data: If the data is a number then it will be considered as index, else, the first preference then goes to title. If an image with specified title is found then click, otherwise, search for an image with property. Alt = incoming data	Yes	String
Row	Enter the row number of the cell in which the image is present. Row number starts at 1.	Yes	String
Column	Enter the column number of the cell in which the image is present.	Yes	String

Example:
ClickImageInCell "2" "2" "3"

StoreRowNoContainingCellText

This action stores the row number of the cell whose data contains the text specified by the user. This comparison is case-sensitive .When multiple cells in the column specified contain the expected data, then the first row number shall be stored in the variable. This can also be applicable for tables where each row in the table has different number of columns.

Input Parameters:

Parameter Name	Parameter Description	Mandatory	Data Type
Key	Enter the key name under which the row number will be stored.	Yes	String
cellText	Enter the cell data you want to search in the table.	Yes	String
Column	Enter the column number of the cell in which the data is present.	Yes	String

Example:
StoreRowNoContainingCellText "key" "word" "2"

SetTextinCellEdit

This action sets text in the specified cell of the table.

Input Parameters:

Parameter Name	Parameter Description	Mandatory	Data Type
Row	Enter the row number of the cell in which you want to enter the data. Row number starts at 1.	Yes	String
Column	Enter the column number of the cell in which you want to enter the text. Column number starts at 1.	Yes	String
text	Enter the text you want to enter in the cell.	Yes	String

Example:
SetTextinCellEdit "3" "2" "Qualitia"

SecureSetTextinCellEdit

This action sets the specified text in the specified cell of the table. Once you move focus from the cell, Qualitia encrypts the text for security purpose.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

Row

Enter the row number of the cell in which you want to enter the text. Row number starts at 1.

Yes

String

Column

Enter the column number of the cell in which you want to enter the text. Column number starts at 1.

Yes

String

text

Enter the text which you want to add in the cell in the specified format.

Format: Encrypt(<TEXT TO BE ADDED>)

No

String

Example:
SetTextinCellEdit "3" "2" "Encrypt(Abc)"

When the focus is moved away from the parameter, Qualitia will automatically encrypt the data ABC and result in a secured text like "vHpmlfI4R3PQkCN4sZnuqw==þNWE3ZDdkNjE3N2JmNDM2ODgxMzQwYWI1MTA3YWNjMDc="

DeSelectCheckBoxInCell

This action deselects the check box from the specified table cell. This can also be applicable for tables where each row in the table have different number of columns.

Input Parameters:

Parameter Name	Parameter Description	Mandatory	Data Type
Row	Enter the row number from where you want to select the check box. Row number starts at 1.	Yes	Integer
Column	Enter the column number from where you want to select the check box. Row number starts at 1.	Yes	Integer

Example:
DeSelectCheckBoxInTableCell "2" "5"
This will deselect the check box present in the second row and the fifth column cell in the table. If the check box is already deselected then the action will pass.

CompareRowData

This action compares the entire record in the specified row with the expected array data.

Input Parameters:

Parameter Name	Parameter Description	Mandatory	Data Type
Row	Enter the row number from which you want to compare the data. Row number starts from 1.	Yes	Integer
rowData	Enter the entire row data expected to be present in a specified row. Separate multiple items with carat (^) operator.	Yes	Array.

Example:
Consider a table containing the data India, Australia, England in row 2. If this data needs to be verified, the action can be used as follows.

CompareTableRowData "2" "India^Australia^ England"

CompareColumnData

This action compares the entire record in the specified column with the expected array data.

This is only applicable for tables having the same number of columns in all the rows.

Input Parameters:

Parameter Name	Parameter Description	Mandatory	Data Type
Column	Enter the column number of table from which you want to compare the data. Column starts from 1.	Yes	Integer
colData	Enter the entire column data expected to be present in a specified column. Separate multiple items with carat (^) operator.	Yes	Array

Example:
Consider a table containing the data India, Australia, England in Column 4. If this data needs to be verified, the action can be used as follows:
CompareColumnData "4" "India^Australia^ England"

VerifyDataExistenceInColumn

This action verifies the existence of the expected data in the specified column. The expected data can be a sub-list of the actual column data in the table.

This is only applicable for tables having the same number of columns in all the rows.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

Column

Enter the column number table where you want to verify the data. Column number starts at 1.

Yes

Integer

data

Enter the data to be searched in a column. Separate multiple items with carat (^) operator.

Yes

Array

existence

Value of this parameter can be either true or false.

Set True if you want to check the existence.
Set False if you want to check the non-existence.

Yes

String

Example:
VerifyDataExistenceInColumn "2" "Test" "True"

This will verify if the data Test is present in the column 2 of the table.

VerifyDataExistenceInColumn "2" "Test" "False"

This will verify if the data Test is not present in the column 2 of the table.

StoreInstanceOfDataFromColumn

This action stores the number of occurrences of the specified data in columns. The data comparison is case-sensitive.

Input Parameters:

Parameter Name	Parameter Description	Mandatory	Data Type
Key	Enter the key name under which you want to store the occurrences.	Yes	String
Column	Enter the column number where you want to search the data. Column number starts at 1.	Yes	Integer
Data	Enter the data you want to search in the specified column.	Yes	String

Example:
StoreInstanceOfDataFromColumn "result" "3" "Qualitia"

StoreRowNumWithRowData

This action stores the row number of the table which contains the specified data.

Input Parameters:

Parameter Name	Parameter Description	Mandatory	Data Type
rowData	Enter the entire row data expected to be present in a specified row. Separate multiple items with carat (^) operator.	Yes	Array
Key	Enter the key name under which the row number will be stored.	Yes	String

Example:
Consider a table containing the following data:

India is in column 1 of a row,
Australia is in column 3 of the same row,
England is in column 6 of the same row,

If the row number for this entry is to be retrieved, the action can be used as follows:

StoreRowNumWithRowData "1^India^3^Australia^6^ England" "RowNumber"

Thus it will check the data "India" in the first column of the table, "Australia" in the third column and "England" in the 6^th column in a particular row. Thus, the data needs to be present in the same row.

SelectCheckboxInCell

This action selects a check box from the specified cell of the table. This can also be applicable for tables where each row in the table have different number of columns.

This step will pass if the check box is already selected.

Input Parameters:

Parameter Name	Parameter Description	Mandatory	Data Type
Row	Enter the row number of the cell from which you want to select the checkbox. Row number starts at 1.	Yes	String
column	Enter the column number of the cell from which you want to select the checkbox. Column number starts at 1.	Yes	String

Example:
SelectCheckboxInCell "2" "3"

VerifyImageInCell

This action verifies that the image present in the specified cell is having the specified scr/title attribute.

Input Parameters:

Parameter Name	Parameter Description	Mandatory	Data Type
Row	Enter the row number of the cell from which you want to verify the image. Row number starts at 1.	Yes	String
column	Enter the column number of the cell from which you want to verify the image. Column number starts at 1.	Yes	String
ScrTitle	Enter either the scr or title data of the image. First the source property will be compared with the actual source and if not present then the title property will be verified.	Yes	String

Example:
VerifyImageIncell "4" "6" "Review"

Macro lookup error: excerpt "ClickAt" was not found on page "WebButton Actions" (with ID 221643190) in space "QFWM".

If you're experiencing issues please see our Troubleshooting Guide.

VerifyLinkTitleAtCell

This action verifies title of link in the given cell. It does not perform an exact match. It performs a contain match.

Input Parameters:

Parameter Name	Parameter Description	Mandatory	Data Type
link	Enter the title data of the link.	Yes	String
row	Enter the row number of the cell in which you want to verify the link. Row number starts at 1.	Yes	String
column	Enter the column number of the cell in which you want to verify the link. Column number starts at 1.	Yes	String

Example
VerifyLinkTitleAtCell "ClickHere" "5" "10"

ClickCell

This action clicks the specified cell from the table.

Input Parameters:

Parameter Name	Parameter Description	Mandatory	Data Type
row	Enter the row number of the cell which you want to click. Row number starts at 1.	Yes	String
column	Enter the column number of the cell which you want to click. Column number starts at 1.	Yes	String

Example
ClickCell "5" "10"

ClickRadioButtonInCell

This action clicks a radio button in the specified cell of the table. This can also be applicable for tables where each row in the table has different number of columns.

Input Parameters:

Parameter Name	Parameter Description	Mandatory	Data Type
row	Enter the row number of the cell from which you want to click the radio button. Row number starts at 1.	Yes	String
column	Enter the column number of the cell from which you want to click the radio button. Column number starts at 1.	Yes	String

Example:
ClickRadioButtonInCell "2" "3"

StoreTableData

This action stores the data of multiple columns of the table into the specified file.

You may use the parameter "noOfPageNext" if you want to store the data laid out in the table across multiple pages.

Input Parameters:

Parameter Name	Parameter Description	Mandatory	Data Type
locatorOfPageNext	Enter the locator of the object which is used to navigate to the next page. If the table is not to be navigated, then this parameter can be "". The locator has to be only an XPATH	Yes	String
columsToStore	Enter the index of columns whose data you want to store in the file. In you want to store multiple columns, separate the column index with the carat (^) operator.	Yes	Array
noOfPageNext	Set the number of times page next needs to be clicked to store the data laid out in a table across multiple pages. If only the current page table data needs to be stored, this parameter should be set as "0".	Yes	String
fileToStore	Enter the complete path of the file in which you want to store the data. The file types supported are .xml, .xls, and .txt.	Yes	String

Example
StoreTableData "//[@id=":cf"]" "1^2^3 2" "0" "C:\DBResults\Excel\ORACLE\Result.xls"

StoreColumnNumber

This action stores the column number with the specified column name. This is only applicable for tables having same number of columns in all the rows.

Input Parameters:

Parameter Name	Parameter Description	Mandatory	Data Type
key	Enter the key name under which you want to store the column name.	Yes	String
columnName	Enter the column name whose number you want to store.	No	String

Example:
StoreColumnNumber "key" "Column 1"

Macro lookup error: excerpt "WaitForObject" was not found on page "WebButton Actions" (with ID 221643190) in space "QFWM".

If you're experiencing issues please see our Troubleshooting Guide.

StoreColumnData

This action stores the column data of the specified column number. This is only applicable for tables having same number of columns in all the rows.

The data is separated by caret (^).

Input Parameters:

Parameter Name	Parameter Description	Mandatory	Data Type
key	Enter the key name under which you want to store the column number.	Yes	String
column	Enter the column number of the cell whose data you want to store. Column number starts at 1.	Yes	String

Example:
StoreColumnData "key" "2"

StoreRowData

This action stores the data from the specified row number.

The data is separated by caret (^).

Input Parameters:

Parameter Name	Parameter Description	Mandatory	Data Type
key	Enter the key name under which you want to store data from row.	Yes	String
row	Enter the row number of the cell whose data you want to store. Row number starts at 1.	Yes	String

Example:
StoreRowData "key" "2"

VerifyDataExistenceInRow

This action verifies the existence of the specified data in the specified row. The expected data can be a sub-list of the actual column data in the table.

This is only applicable for tables having same number of columns in all the rows.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

Row

Enter the row number of the table where you want to verify the existence. Row number starts from 1.

Yes

Integer

rowData

Enter the data to be searched in a row. Separate multiple data with the caret (^) operator.

Yes

Array

existence

Value of this parameter can be either True or False.

Set True if you want to check for the existence.
Set False if you want to check for the non-existence.

No

String

Example:
VerifyDataExistenceInRow "2" "Test" "True"
This shall verify if the data Test is present in the row 2 of the table

Macro lookup error: excerpt "RightClick" was not found on page "WebElement Actions" (with ID 221643171) in space "QFWM".

If you're experiencing issues please see our Troubleshooting Guide.

StoreRowNumberHavingMinCellDataincolumn

This action stores the row number of the table which contains the minimum value of integer data from the specified column.

Input Parameters:

Parameter Name	Parameter Description	Mandatory	Data Type
Key	Enter the key name under which you want to store the row number.	Yes	String
Col	Enter the column number where search for the minimum value. Column number starts at 1.	Yes	Integer

Example:
StoreRowNumberHavingMinCellDataincolumn "rowNumber" "4"

StoreRowNumberContainsMaximumValue

This action stores the row number of the table which contains the maximum value of integer data in the column specified by user.

Input Parameters:

Parameter Name	Parameter Description	Mandatory	Data Type
Key	Enter the key name under which you want to store the row number.	Yes	String
Col	Enter the column number where search for the maxmum value. Column number starts at 1.	Yes	String

Example:
StoreRowNumberContainsMaximumValue "rowNumber" "2"

VerifyTableRowCount

This action verifies the actual row count of the specified table with the expected row count.

Input Parameters:

Parameter Name	Parameter Description	Mandatory	Data Type
rowCount	Enter the expected row count which you want to compare with the actual row count.	Yes	Integer

Example:
VerifyTableRowCount "6"

VerifyCellText

This action verifies the actual data of the specified cell with the expected cell data.

This comparison is case-sensitive.

Input Parameters:

Parameter Name	Parameter Description	Mandatory	Data Type
data	Enter the data which you want to verify in the table cell.	Yes	String
Row	Enter the row number of the cell. Row number starts at 1	Yes	String
Col	Enter the column number of the cell. Column number starts at 1.	Yes	String

Example:
VerifyCellText "Good Morning" "2" "3"

ClickLinkAtCellandchooseOkOnConfirmation

This action clicks a link in the specific cell of the table. This is applicable for tables having same number of columns in all the rows. After clicking the link, if an alert or confirmation appears, this action will accept it by clicking OK.

This step fails if the link is clicked and no alert or confirmation appears.

Input Parameters:

Parameter Name	Parameter Description	Mandatory	Data Type
Link	Enter the URL to click.	Yes	String
Row	Enter the row number of the cell where the link is present. Row number starts at 1.	Yes	String
Column	Enter the column number of the cell where the link is present. Column number starts at 1.	Yes	String

Example:
ClickLinkAtCellandchooseOkOnConfirmation "http://www.google.com" "2" "3"
Note: If Link is an empty data ("" or $NULL$), and there are multiple links in the cell, then the first link in the cell will be click. If there are multiple links in the cell with the same text, then the first link will be clicked. However, if there is no link available in the cell, the action will fail with an error message that no link is available in the cell.

Macro lookup error: excerpt "ClickAndWait" was not found on page "WebButton Actions" (with ID 221643190) in space "QFWM".

If you're experiencing issues please see our Troubleshooting Guide.

StoreRowNoContainingTextInArray

This action stores the row number which contains the combination of specified text.

Input Parameters:

Parameter Name	Parameter Description	Mandatory	Data Type
Key	Enter the key name under which you want to store the row number.	Yes	String
cellText	Enter the text combination which you want to check in the columns.	Yes	Array
Col	The column number of the cell in which you want to search the combination of data. Column number starts at 1	Yes	String

Example:
StoreRowNoContainingTextInArray "rowNo" "John^Smith" "3"
This will search for the combination of John and Smith in the column 3 of the table for all the rows.The row which contains this combination will be stored in the key "rowNo"

GenerateAndStoreMaximumValue

This action fetches the column data having the maximum value. It then adds an increment value to it and stores it under the specified key.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

Key

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

Yes

String

Col

Enter the column number of the cell from which you want to find the maximum data. Column number starts at 1.

Yes

String

incr

Enter the value by which the maximum data found in the column is to be incremented/decremented.

If this value is "" empty string, then the default increment is 0.

No

String

Example:
GenerateAndStoreMaximumNumber "key" "3" "2"

ClickLinkAtCellTH

This action clicks a link from the specific cell of the table header. This is applicable for tables having same number of columns in all the rows.

Input Parameters:

Parameter Name	Parameter Description	Mandatory	Data Type
Link	Enter the link to click.	No	String
Row	Enter the row number of the cell from the link is to be clicked. Row number starts at 1.	Yes	String
Col	The column number of the cell from which the link is to be clicked. Column number starts at 1	Yes	string

Example:
ClickLinkAtCellTH "http://www.google.com" "2" "3"
Note: If Link is an empty data ("" or $NULL$), then the first link in the cell will be click. If there are multiple links with the same text then the first link will be clicked. However, if there is no link available in the cell, the action will fail with an error message that no link is available in the cell.

ClickLinkTitleAtCell

This action clicks a link based on the title in the specific cell of the table. This is applicable for tables having same number of columns in all the rows.

Input Parameters:

Parameter Name	Parameter Description	Mandatory	Data Type
Link	Enter the link title which you want to click.	Yes	String
Row	Enter the row number of the cell from the link is to be clicked. Row number starts at 1.	Yes	String
Col	The column number of the cell from which the link is to be clicked. Column number starts at 1.	Yes	String

Example:
ClickLinkTitleAtCell "google" "2" "3"
Note: If Link is an empty data ("" or $NULL$), and there are multiple links in the cell, then the first link in the cell will be clicked. However, if there is no link available in the cell, the action will fail with an error message that no link is available in the cell.

ClickCheckboxInCellTH

This action selects the check box from the specified header of the table.

This step will pass if the check box is already selected.

Input Parameters:

Parameter Name	Parameter Description	Mandatory	Data Type
Row	Enter the \row number of the cell from which the checkbox is to be clicked. Row number starts at 1.	Yes	String
Column	Enter the column number of the cell from which the checkbox to be clicked. Column number starts at 1.	Yes	String

Example:
SelectCheckboxInCell "2" "3"

ClickImageInCellTH

This action clicks the image in the specified cell of the table.

Input Parameters:

Parameter Name	Parameter Description	Mandatory	Data Type
alt_title	Enter the attribute of the image alt or title. First preference then goes to title and if an image with specified title is found then click, else, search for an image with property. Alt = incoming data	Yes	String
Row	Enter the row number of the cell from which the image is to be clicked. Row number starts at 1.	Yes	String
Col	Enter the column number of the cell from which the which the image is to be clicked.	Yes	String

Example:

ClickImageInCellTH "2" "2" "3"

Macro lookup error: excerpt "StoreExistence" was not found on page "WebButton Actions" (with ID 221643190) in space "QFWM".

If you're experiencing issues please see our Troubleshooting Guide.

Macro lookup error: excerpt "StoreChildCount-withoutlocator" was not found on page "WebButton Actions" (with ID 221643190) in space "QFWM".

If you're experiencing issues please see our Troubleshooting Guide.

Macro lookup error: excerpt "ScrollIntoView" was not found on page "WebButton Actions" (with ID 221643190) in space "QFWM".

If you're experiencing issues please see our Troubleshooting Guide.

Macro lookup error: excerpt "ClickJS" was not found on page "WebButton Actions" (with ID 221643190) in space "QFWM".

If you're experiencing issues please see our Troubleshooting Guide.

Macro lookup error: excerpt "ActionClick" was not found on page "WebButton Actions" (with ID 221643190) in space "QFWM".

If you're experiencing issues please see our Troubleshooting Guide.

StoreColumnCount

StoreRowCount

On this page:

StoreCellText

ClickLinkAtCell

StoreRowNoOfCellText

ClickImageInCell

StoreRowNoContainingCellText

SetTextinCellEdit

SecureSetTextinCellEdit

DeSelectCheckBoxInCell

CompareRowData

CompareColumnData

VerifyDataExistenceInColumn

StoreInstanceOfDataFromColumn

StoreRowNumWithRowData

SelectCheckboxInCell

VerifyImageInCell

VerifyLinkTitleAtCell

ClickCell

ClickRadioButtonInCell

StoreTableData

StoreColumnNumber

StoreColumnData

StoreRowData

VerifyDataExistenceInRow

StoreRowNumberHavingMinCellDataincolumn

StoreRowNumberContainsMaximumValue

VerifyTableRowCount

VerifyCellText

ClickLinkAtCellandchooseOkOnConfirmation

StoreRowNoContainingTextInArray

GenerateAndStoreMaximumValue

ClickLinkAtCellTH

ClickLinkTitleAtCell

ClickCheckboxInCellTH

ClickImageInCellTH

Not finding what you need?

Parameter Name	Parameter Description	Mandatory	Data Type
key	The variable name in which the cell text is to be stored.	Yes	String
Row	The row number of the cell. Row number starts at 1.	Yes	String
Column	The column number of the cell. Column number starts at 1.	Yes	String

WebTable Actions

StoreColumnCount

StoreRowCount

On this page:

StoreCellText

ClickLinkAtCell

StoreRowNoOfCellText

ClickImageInCell

StoreRowNoContainingCellText

SetTextinCellEdit

SecureSetTextinCellEdit

DeSelectCheckBoxInCell

CompareRowData

CompareColumnData

VerifyDataExistenceInColumn

StoreInstanceOfDataFromColumn

StoreRowNumWithRowData

SelectCheckboxInCell

VerifyImageInCell

VerifyLinkTitleAtCell

ClickCell

ClickRadioButtonInCell

StoreTableData

StoreColumnNumber

StoreColumnData

StoreRowData

VerifyDataExistenceInRow

StoreRowNumberHavingMinCellDataincolumn

StoreRowNumberContainsMaximumValue

VerifyTableRowCount

VerifyCellText

ClickLinkAtCellandchooseOkOnConfirmation

StoreRowNoContainingTextInArray

GenerateAndStoreMaximumValue

ClickLinkAtCellTH

ClickLinkTitleAtCell

ClickCheckboxInCellTH

ClickImageInCellTH

Not finding what you need?