Documentation

Get EXCEL Sheet Row Count: GET_ROW_COUNT

The Get EXCEL Sheet Row Count action retrieves the total number of rows in a specified Excel sheet. This is useful when working with large datasets, enabling automation workflows to iterate through rows efficiently.

Example: Suppose you have an Excel file containing employee records and need to determine the total number of rows in Sheet1 for processing.

Steps to Configure:

1. Select Get EXCEL Sheet Row Count from the Action drop-down.
2. Leave the Screen Name field blank.
3. In the Element Key field, enter a variable name to store the row count (e.g., rowCountVar).
4. In the Parameter section, provide the following details in a comma-separated format:
   • File Path: The full path of the Excel file (e.g., C:/Documents/EmployeeRecords.xlsx).
   • Column Name: The column to check for row count (e.g., “Employee Name”).
   • Sheet Number: The sheet index or name (e.g., 1 or “Sheet1”).
   • H/V (Horizontal/Vertical) Orientation: Specify whether the data should be counted horizontally or vertically (H for horizontal, V for vertical).

Example Input Format: C:/Documents/EmployeeRecords.xlsx,Employee Name,1,H

5. Click Save.

Note: These steps follow the same process in both Tabular View and Card View.

Expected Outcome on Execution:

• The action counts the total number of rows in the specified Excel sheet and stores the value in the variable (e.g., rowCountVar).
• For example, if Sheet1 contains 100 rows, rowCountVar will hold the value 100, which can be used in subsequent steps using the syntax ${rowCountVar}.