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 ?