Project with Excel Parameters

Example of a project that receives an initial parameter of type Excel

As pictured above, a spreadsheet in which the first column stands for a code and the second for an individual's name has been set.

When the spreadsheet is entered as the initial parameter, it will be available as follows during robot execution:

[
  [
    123457,
    "Smith"
  ],
  [
    123458,
    "Michael"
  ],
  [
    123459,
    "Mike"
  ],
  [
    123450,
    "Julia"
  ]
]

From this you can use the Free Loop object to get every row in this list, for example:

1 - Add new project:

2 - Next, include in the working area the Free Loop object and configure it as follows:

Condição (contador menor que a quantidade de linhas do array)

To access the information you should use the concept of rows by columns, for example:

// Buscará o código disponível na primeira coluna da planilha
Planilha[count][0]

// Buscará o nome disponível na segunda coluna da planilha
Planilha[count][1]

As per the image below, this approach was used to display the values for each row and column of the file.