Loops

Easy Excel Framework

Loops Overview

Loops provide a way of iterating over data or a set number of times and calling a worksheet with the relevant data for that iteration

Actions

Loop [Worksheet to iterate] [Worksheet to Call]

Loops through one Worksheet passing that rows values to another Worksheet to Execute

e.g.

Main Sheet

Action
Loop	MySheet	CalledSheet

MySheet

Test Data 1
Test Data 2
Test Data 3
Test Data 4

CalledSheet

Action
Do Action	PARAM1

MainSheet Row 1 loops through the rows in MySheet calling CalledSheet with the row of data as the parameters

Loop [Iterations]

Call a worksheet a set number of times

e.g.

Action
loop	3	CalledSheet

Calls CalledSheet 3 times

Action
Set Local Int	MyInt	5
loop	MyInt	CalledSheet

Calls CalledSheet MyInt times