Question

Hi Team, Can anyone help me how can i drag the excel formula and update the rest of the cells.


Hi Team, Can anyone help me how can i drag the excel formula and update the rest of the cells.

3 replies

Userlevel 3
Badge +7

Hi @OM Mishra​ ,

 

Please check out the below link

Set Cell Formula in Excel AutomationAnywhere A2019 ...

Badge +4

Hi @Tamil Arasu10 it took quite long time to have the formula for the rest of the column if rows if more than 2k. Is there any better solution?

Userlevel 7
Badge +11

Hi @usernsj,

Using Set Cell Formula within a loop and increment the Row number will be the suitable. But since your data is huge, I would recommend to you the Database package through which, the execution will be faster.

Reply