Sign In
Create your first automation in just a few minutes.Try Studio Web →
Tech Mahindra - Drag and Drop Formula for Excel
by YouTube
2
Snippet
185
Summary
Summary
Plug & Play BOT, a ready-to-use UiPath workflow or Excel Automation across projects
Overview
Overview
Introducing the Plug & 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 & drop formula in a cell range.
Successfully tested the execution for different customers. It works very well without any change in code.
- Project repository details:/Data/Input/Sample.xlsx
- Excel Drag & Drop Formula.xaml
- xaml
project.json
Features
Features
Easy use of Excel spreadsheets
Additional Information
Additional Information
Dependencies
Created it using the excel activities of UiPath and keyboard shortcuts to drag and drop the formula across the selected range. Configured the BOT to read workbook name, sheet name and column name from the input argument type. BOT will throw an exception in case any error encountered at run-time.
Code Language
Visual Basic
Technical
Version
1.0Updated
February 18, 2020Works with
Tested the backward compatibility with 2017 release of UiPath. It works very well. It is created with 2018.2.3 release of UiPath Studio.
Certification
Silver Certified
Tags
Support
UiPath Community Support
Resources
Similar Listings