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

#6

TRIAL

Hi,
I need to look for same account number in the column and then if same account exists i have to compare the respective security number, if security numbers are same then i have to sum the balance. Could you please help me out.

expecting: 1234 in A2 and 1234 in A3 are same then go to security number 987 in B2 is same as 987 in B3, then add C2 and C3.