Skip to main content

ForEachInEXcellCell

Iterates through Excel cells or rows within a defined range and executes actions for each iteration.

Core Functions

  • Iterates over Excel data by cell range or row indexes
  • Exposes the current iteration data for use inside the loop

Inputs

  • StartCell: Specifies the starting Excel cell address where the iteration begins.

  • Type::String

  • EndCell:Defines the starting row index for the iteration when looping by rows.

  • Type:: String

  • StartRow: Defines the starting row index for the iteration when looping by rows.

  • Type::Integer

  • EndRow:Defines the ending row index for the iteration when looping by rows.

  • Type::Integer

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

  • Type:: DataTable

Outputs

  • LoopParameter:Holds the current cell or row data during each iteration and can be used inside the loop body.
  • Type:: Object

Short Technical Summary A loop activity that processes Excel data by iterating through cells or rows using a specified range or DataTable, enabling flexible Excel-driven automation.