Excel Addition in cell

I have an excel below with data marked in the cell.

So here in 2020Pol and 2022 Pol I have already data now i want to add data to the same cell not replacing but by adding

Eg :-1:

2020Pol is having data 22.50 in one cell now i have a value 20 to add in the same cell so i need an output like 42.50 in the cell.

Is it possible to use excel properties to invoke in UiPath to get the solution instead of reading the entire sheet and adding the data in the cell separately and again write it.

Hi @Gokul_Murali ,

here you can follow different approaches,

  1. you can get the cell value and with that value you can add and re write in the same cell.
    2.Use macros to solve this issue

What is the logic in identifying what value to add. In the above example - you are adding 22.5 + 20. How to derive this 20. Is this also something available in the same sheet or a hard coded value?

@sharazkm32

I am processing another excel to get get the value

@Gokul_Murali

you can use for each row in excel and inside that get the current cell value you need and add and write back

cheers

@Gokul_Murali You can use the “Get Cell Value” activity to retrieve the cell’s value, add the required amount to it, and then update the cell using the “Write Cell” activity.