Task Office - Excel - Get Row Count
The Excel - Get row count Task counts the rows of a worksheet in an Excel workbook and writes the number to the output of the Task.

The Main settings, Flow, On error, Conditions and TimeOut tabs are the same for every Task; see Job - Tasks.
Excel - Get row count tab
-
Credentials: The Credential used to read the workbook, for example on a network share; see Credentials
Select a Credential in the combo box, or click the Settings icon to add or edit Credentials.
-
Select Excel file: The full path of the workbook; it can contain Variables
-
Password: The password that opens a protected workbook, used only when the workbook is encrypted
Worksheet
-
Use first worksheet: Counts the rows of the first worksheet
-
Use specific worksheet: Counts the rows of the worksheet with the name you enter or select
Click Get to list the worksheets of the workbook in Select Excel file. The Client reads that file, so the path must be reachable from the computer that runs the Client. The name can contain Variables.
Output and errors
The output of the Task is the number of rows that the worksheet holds. A workbook or worksheet that cannot be read stops the Task with an error.