Read excel value dynamically

[Sindujaravi]

Hi
I am automating browser application in that i need to place one order which may "n" number of line items so for each line i need to enter the quantity.

I will inspect quantity using dynamic path option. But the problem is for example some order may have 50 line items so for all the line items i cannot add 50 Write stage is BP.

So is there any possibility to give the value of quantity dynamically from excel and also can we store all the values in single quantity field in excel.


------------------------------
Sinduja ravi
------------------------------

[RaviTeja]

Hi Sinduja,

If you get data from Excel and store in collection. Then try iterate loop on the collection to take value and enter it into the field spied.

Increment the dynamic path counter silmentenously before loop end so that next value from loop will go into the next value spied by dynamic path.

Thanks,
Ravi Teja

------------------------------
Ravi Teja
RPA Developer
Accenture
Asia/Kolkata
------------------------------