How to iterate through excel rows using Excel Action library?

excel-loop

#1

I am using RPA Express 1.1.1 Beta version which I got in Download link.
I am now trying to open an excel spreadsheet and iterate through its rows to get inputs from each row in a list. Obviously I am using a loop to do that.
But I am stuck with positional row which I select at the start of the loop.

How do I overcome this issue?


#2

@abhijit_kulkarn,

Please post here your recording


#3

rpae_project.zip (44.1 KB)
Hi
Please find attached my recording.


#4

Also below are my queries:

  1. How can I set a value to a recorder variable using Expression if it is of type String?
  2. how can I set any excel row as current using a Recorder variable? Means suppose I declare a recorder variable of type string, set its value as “A1” and then assign it as index for excel row.

#5

@abhijit_kulkarn,

please find the solution below - How to read excel spreadsheet to a List or Table variable