I am new in the UI Path, need some help to automate a manual task.
Billed and Net amount need to be updated in another excel by searching No’s.
I used For each row-find from excel activities to find No’s position/cell index (A2,A3, etc.) in 2nd excel. both excel can not be sorted so position can be any where. I need to know how i can place Billed and Net amount in next to cell of No in 2nd excel.
Variable “Position” data type used as String and when placing +1 to update the value in next cell. getting error. Please help.
Read data from the current row
No = row("No").ToString();
Billed = row("Billed").ToString();
NetAmount = row("Net Amount").ToString();
Find the row in the second Excel file based on "No"
Position = FindNoInSecondExcel(No);
Update "Billed" and "Net Amount" in the second Excel file
WriteToSecondExcel(Position, Billed, NetAmount);