Loop Through Excel Data

Object to loop through all the data of an Excel file.

Settings

This object depends on the use of the "New Excel" or "Open Excel" object to work.

Field	Descritivo
Title	Object title
Object Identifier Name	Singular object name for searching data in the Excel file
Select Main Object	Option to select an Excel spreadsheet
Reading Conditions	Option to select the reading conditions
Row Counter	Option to count the number of rows in the Excel file
Starting Counter Value	Indicador da linha para início do cálculo - The initial row index from which the counter will start

Example

In order to loop through data in an Excel file you need to follow a few steps:

1 - Select the "Open Excel" object from the "Excel" menu and drag it to your working area.

• First you must define a unique name for the object in the "Object Identifier Name" field, inform the complete directory containing the name and the extension of the file and then set a password if it is required.

2 - Then select the "Loop Through Excel Data" object from the "Excel" menu, enter a name for the object, select the main object, the reading conditions and finally enter the initial value to start the count.