Skip to main content

ForEachInExcellRow

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.