Skip to main content

ForEachInExcelCell

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: Specifies the ending Excel cell address where the iteration stops
    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.