Next Cell Location in Excel

Soumya_Chatterjee · November 16, 2023, 7:00am

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.

Kartheek_Battu · November 16, 2023, 7:04am

Hello @Soumya_Chatterjee

For Each Row (in First Excel)

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);

Thanks & Cheers!!!