Get Total Column Count

This is a pre-built action in Avo Assure and comes under @Excel Element. The functionality of this action in Avo Assure is to fetches the total number of columns in the Excel file and stores the result in a dynamic variable.

Syntax

Input Value: N/A

Argument
Description

N/A

Not applicable

Output Value:

Argument
Description

<Dynamic Variable> (Required)

This dynamic variable holds the total column count.

<Dynamic Variable> (Optional)

This dynamic variable holds the results in True or False

Example:

Retrieves the total number of columns from an Excel sheet The Get Total Column Count action does not require any input in the Input Value column and returns the total count of columns present in the Excel sheet. The result is stored in the {TotalColumns} variable, while the execution status is stored in the {Status} variable as True (if the column count is retrieved successfully) or False (if the operation fails )

Last updated

Was this helpful?