Loop Through Excel Data
Object to loop through all the data of an Excel file.
Last updated
Object to loop through all the data of an Excel file.
Last updated
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
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.
