How to Implement an Excel Formula in UiPath

[@ishaarya5499]

you have been one of the biggest help provider in my career. thankyou so much for all the videos.

[@sandeepreddy4093]

Hi Thank you, but can we use Autofill so that there is no need of looping through datatable? Of course we need to update excel formula little bit but this works.

[@VeloLisa]

Thank you! Big help.

[@AutomatewithRakesh]

Glad it helped!

[@bak1970]

Thank you very much, Rakesh. It has been beneficial since I am doing a lot of Excel automation. 👍

[@bak1970]

Please keep up the good work. 🙂

[@lakshyagarg8533]

hello sir, how to set border dynamicaly using balareva set border activity

[@AutomatewithRakesh]

I think That’s a custom activity created by Balareva I have not used it yet I’ll try to use that and if required will create a content

[@mohdqamaruddin6197]

thank you so much sir

[@SyedAli-iq4ku]

thank you Rakesh

[@jaysizmir9432]

I think you can directly create the index variable from the For each row activity instead of managing the index yourself. It's one of the property of the activity

[@toshi_garg]

Nice and Beautiful

[@arslanahamd7742]

This is the slowest approach if dealing with the real world data.

[@pracashraz007]

Hi, it's nice. But what if the DT contains 50k rows??? Any shortcut to drag the formula or any other solution!!!!

[@parthmodi5112]

Use auto fill range activity

[@sachinsreekumar6795]

@@parthmodi5112 use write cell activity. give the formula of first cell in value

[@girishkrishna4654]

@@sachinsreekumar6795 and also provide the proper range