How to apply formula in different rows of excel file where row number is not fixed it changes according to our need using ui path studio coding. & which activites to be used for this?

[raghav.bhardwaj.external]

How to apply formula in different rows of excel file where row number is not fixed it changes according to our need using ui path studio coding.
in these screen shots row no C and D are not fixed it changes according to our

need.
and please tell how to use it and which activities should be used in Ui Path Studio Coding.

[Anil_G (Anil Gorthi)]

@raghav.bhardwaj.external

You can use write cell activity…

The formula can be provided like this

"=Sum(C7:C20)"

Ifyou want to variablize the. Use like this

"=Sum(" + Variablecolumn + startcell + ":" + variablecolumn + endcell + ")"

Cheers

[jack.chan]

you can try this reusable component
https://marketplace.uipath.com/listings/jack-excel-functions-activities

after downloading the package, use this activity