To create a virtual copy of the Excel file (table), the Excel file related to the Open activity is opened from the Excel activities. Then, using the “Read excel to dataset” activity, the relevant page of the excel file opened in the previous step is kept in memory as a virtual copy (Dataset). The row and column information of the relevant cell is entered by using the “Get action” activity from the dataset activities. The value of the specified cell in this activity is kept in the variable.
In order to repeat this process as much as the number of records (number of lines), first of all, how many forms are in the file should be determined. “Get size” activity from Dataset activities is used for this operation. The virtual copy (Dataset) of the file is selected from the relevant field, and the “Size Type” property is set to “Row.” Enter the variable name to hold the record count. Then, the “Sub-process” structure under the Structural group is used. This structure is used to perform repetitive (cyclic) operations. The “Cardinality” and “Multi-instance type” fields must be specified from the properties of the building. In the Cardinality field, the information for how many rounds the structure will work is entered. The variable name from the “Get size” activity is written in this field as ${number of records} in ${}. To process these records sequentially, the “Sequential” option is selected from the “Multi-instance type” property.
With the sub-process structure, the cyclical structure is prepared. This structure starts from 0 and rotates until one less than the number of turns it will rotate. Since there is an index structure in the dataset structure, the first record should be considered as row 0 and the first column as column 0. The data of ${loopCounter}, which is a particular variable in the structure, can be entered into the “Row” field of the activity you have entered into the variable. This value increases automatically at the end of each round. Once you perform the scenario of your repetitive operation in this area, the robot will understand that this operation is redundant operation and will work in this way.
NOTE: Remember that the sub-process structure must start with “Start event” and end with “End event.”