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
528
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
183
Bronze Certified
Calculate Sum of Colored Cells in Excel Sheet
Snippet
Calculate the Sum of Excel colored cells in any given range
32
Bronze Certified
Excel Range to Image
Custom Activity
This activity converts the given Excel range into an image along with its cells' format
2 reviews
915
Bronze Certified
