I want to increase yellow highlighted part of excel formula for example:
For Cell A1 it will be as shown in image : “=OFFSET(data!$L$2,(ROW(data!$L$1)-1)*2,0)”
but when it goes to next cell A2 it should take L2 : “=OFFSET(data!$L$2,(ROW(data!$L$2)-1)*2,0)”
for A3 it should take L3 and so on…
I am only looking for Excel modern activity, not classic.
Welcome to UiPath Community
Create “Index” variable in For each Excel Row activity then user that variable in write cell activity
If not so use below method
Test.xaml (7.7 KB)
Hi @mavsp8 ,
Alternately, Instead of using
For Each Excel Row, Could you use
Fill Range Activity and Check if it is able to populate the data as required ?
However, Firstly you would need to use
Write Cell Activity first for Cell A2 and then use
Fill Range Activity.
Let us know if you were able to use this method as well.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.