Get Excel Row and Column Count Step

Brief description

This step will provide you with the row and column counts of your Excel sheet.

Step Information

Step name (Not required) – the custom name of the process step that labels the editor’s process step box

Input parameters

• Excel instance name (Required)– value of the unique connection instance name previously defined in the Open Excel File step
• Sheet name (Required)– variable name or value that indicates the name of the Excel sheet
• Has custom columns (Required) - has header columns
  • T (true)
  • F (false- default value)

Output parameters

Column count (Required)– existing or new variable name of integer data type that contains the resulting data table variable count of columns 

Row count (Required)– existing or new variable name of integer data type that contains the resulting data table variable count of rows