My robot has to read a different excel file everyday and perform some steps with the data extracted, the sheet name is different everytime the file changes. I was trying to use read range activity and save it on a datatable variable.
My questions are:
How can i read a different sheet name everytime the robot runs?
how can i access the data in the proccess scope? Because this datatable will only exists when the robot is on execution, right?
You can have the excel file in a particular folder and using
Assign string, filelist=directory.GetFiles("location","*.xlsx") you can get the path of the excel,
Make sure that there is only the required excel files in your speciifed location
To get the sheet name you can follow the below post
Also to get the data extracted from excel you might need to store it somewhere like a queue
It was easyer to rename the column name using write cell, because this column will always be h1.
My question at this point is: after read range executes successfully, how can i access the datas stored in datatable? will the first value of the column in excel becomes the name of the column in datatable? I’ve marked this option in read range activity