Hi @OM Mishra ,
Please check out the below link
Set Cell Formula in Excel AutomationAnywhere A2019 ...
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?
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.
On large data sets I have two options for you. Hopefully this helps and let me know if you have any follow up questions.
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.