Create an array from excel range

RPA Automation How to build
1

Hi everybody
I have an excel sheet from which I need to create several arrays using different ranges

It is possible to create a variable whose value is an array extracted from a range in excel using the “calculate value” option with a formula like: archivo_passwords[‘pass’][C2:C16]

Screenshot_40
Screenshot_40994×652 31.3 KB

The goal is to read the excel file only once and not use Read Range multiple times

3 Likes
2

Hi @Yoshi,

I think it is possible to create an array from data in a excel sheet.

  1. you create a variable x = [ ]
  2. you read data from excel sheet
  3. you can make a loop to select data, you need exactly
  4. you can add data to the end of array using x.push(“value1”);
    (in this case you can use activity “execute js code”)

Regards,
Mikhail

1 Like