Read each excel cell and save it to an array

excel
activities

#1

Hi guys,

I have an Excel file with 4 columns: A B C D and an x number of rows. I would like to read this excel file starting from A2 to the entire length of the populated sheet, and store the read values into an array which I can later use in my automation process. For example: if value of A2 == “some value” execute part of this process. Else, go to the next process.

Basically my question is, how can i store all those values from excel into one or more arrays which I can use later as reference ?


#2

@rafaelb Using Read Range activity, u can store data into datatable.
From datatable u can do operations