Skip to main content
Version: 16

EXCEL_COUNT_FILLED_ROWS

Counts the filled rows in a column of an excel spreadsheet.

Description

Counts the filled rows in a column of an excel spreadsheet. This command works only if an excel file was previously opened with the EXCEL_OPEN command. After all the operations with a specific excel file are done within a script, it is advised to close the excel file with the EXCEL_CLOSE command.

Syntax

EXCEL_COUNT_FILLED_ROWS [Worksheet name] [Column name] [Result variable]

Command parameters

Command parameterAssignmentValue formatInput options
Worksheet nameRequiredStringLocal, variable
Column nameRequiredStringLocal, variable
Result variableRequiredStringLocal, variable

Worksheet name:

Name of the worksheet within the currently opened excel file.

Column name:

Name of the column within the specified worksheet of the currently opened excel file.

Result variable:

Name of variable that will store the number of the filled rows.

Sample code

Command only:

EXCEL_COUNT_FILLED_ROWS Sheet1 A Excel_Row_Count

With added prerequisites:

EXCEL_OPEN c:\Temp\Sample_Excel.xlsx
EXCEL_COUNT_FILLED_ROWS Sheet1 A Excel_Row_Count