Skip to main content

ForEachInExcelRow

Iterates through Excel rows within a specified range and executes actions for each row.

Core Functions

  • Iterates over Excel data row by row
  • Tracks the current row index during each iteration

Inputs

  • StartRow: Defines the starting row index where the row iteration begins
    Type: Integer

  • EndRow: Defines the ending row index where the row iteration stops
    Type: Integer

  • ExcelDataTable: Represents the Excel data loaded as a DataTable and used as the iteration source
    Type: DataTable

Outputs

  • CounterVariable: Stores the current row index for each iteration and can be used inside the loop
    Type: Integer

Short Technical Summary

A row-based loop activity that iterates through a DataTable using defined start and end row indexes, providing the current row index during execution.