English
Summary
This activity is used for Excel manipulation with user defined formulas
Overview
This package contains 3 different activities that are useful for adding and removing formulas in a particular Excel range:
1. ApplyFormula: Applies formula in particular cell or range. It works only when the Excel file is closed.
2. RemoveFormulaAndKeepValues: Keeps Values and removes formula in particular cell or range. If the cell has no formula it will keep the values as they are.
3. RemoveFormulaWithValues: Removes formula and values in particular cell or range.
Benefits
Published: 16 Sep 2020 | Updated: 17 Oct 2020
Trusted Source
License
MIT
Code Language
Visual Basic
Runtime
.NET Framework
Tags
Apply formula
cell
excel
formula
range
Remove formula and keep values
remove formula and values
Compatibility
UiPath Studio 20.4.1
Dependencies
UiPath Studio 20.4.1
Documentation
Support
UiPath Community SupportSimilar Listings
Hexaware - Excel Activities
Custom Activity
This component contains all activities required for Excel
444
Bronze Certified
Novigo Solutions - Get Cell Name
Custom Activity
This activity takes DataTable as input and returns a dictionary containing column name and the respective cell name
2 reviews
177
Bronze Certified
Calculate Sum of Colored Cells in Excel Sheet
Snippet
Calculate the Sum of Excel colored cells in any given range
27
Bronze Certified
Feat Systems - Mathematical Functions
Custom Activity
This activity is capable of calculating different mathematical functions
232
Bronze Certified
