Tech Mahindra Limited is an Indian multinational provider of information technology (IT), networking technology solutions and Business Process Outsourcing (BPO) to various industry verticals and horizontals.&nbsp;&nbsp;

Introducing the Plug &amp; Play BOT, a ready-to-use UiPath workflow for Excel Automation that can be integrated easily with any project across different customers that too without any modification.Updating formula is one of the common functionality that we come across in almost every RPA implementation for Excel Automation and every time the developers need to re-create the workflow to do this activity.It fills the formula across all the rows of a column in an excel workbook by using the keyboard shortcuts for drag &amp; drop formula in a cell range.Successfully tested the execution for different customers. It works very well without any change in code.<ol><li>Project repository details:/Data/Input/Sample.xlsx</li><li>Excel Drag &amp; Drop Formula.xaml</li><li>xaml</li></ol>project.json

Plug & Play BOT, a ready-to-use UiPath workflow or Excel Automation across projects

Project Lead

Why you are  not using Autofill activity to fill the formula ? 

 - Very useful and easy to configure snippet when Excel integration is needed in your automation


 - Simple to set up, produces good and useful outcome.


Tech Mahindra - Drag and Drop Formula for Excel

Tech Mahindra - Drag and Drop Formula for Excel

Help

How To