Get Total Column Count

This pre-built action in Avo Assure under @Excel element instructs Avo Assure Client to fetch the total count of columns existing in the Excel file and save the result in the output variable.

Syntax:

Input: row number (optional)

Note: It is essential when the user needs column count of Particular row.

Output: <Dynamic Variable> ;< Dynamic Variable> (Optional)

Use case/Example

Scenario: Verify Column Count in a User Management Table

When testing a feature of an excel sheet, the action ensures the User Management table on the admin dashboard displays the correct number of columns. This ensures that the User Management table has the correct structure by verifying the number of columns.

1. Input Data:

• NA

• In optional case, user gives a row number for specific work.

2. Expected Result:

• The variable {Result} holds the number of Total counts of column present in the Userdetails sheet of the Excel file.

• It should Store the Total counts of column in an output variable.

Output: The output variable {Result} contains the total counts of column in an excel sheet.