English
Calculate Sum of Colored Cells in Excel Sheet
Bronze Certified
0 reviews
33
Calculate Sum of Colored Cells in Excel Sheet
Bronze Certified
0 reviews
33
Summary
Calculate the Sum of Excel colored cells in any given range
Overview
- Colorcell - this is the reference cell. Manually enter the color, the same as the one in the data range. Then enter the cell number in the Argument Value. E.g. G6
- Range – type in the data range. E.g. D6:E21
- SheetName – enter the name of the sheet where the data, Colorcell and SumResult, are displayed. E.g. Sheet2
- SumResult – add here the location where the Sum obtained after Bot execution will be displayed. E.g. H6
- Workbookpath – enter the full Excel file path.
- OutputValue- use this optional argument to store the end result.
- wb – use this optional argument to close the workbook after the execution is completed.
- Enable it by following the path: from your Excel access File > Options > Trust Center > Trust Center Settings > Macro Settings > Select the Trust Access to the VBA project object model check box.
Benefits
Published: 25 Oct 2019 | Updated: 30 Sep 2020
License
MIT
Code Language
Visual Basic
Runtime
Windows Legacy (.Net Framework 4.6.1)
Tags
Compatibility
UiPath Community version - 2019.10
Dependencies
Excel, UiPath 2019.10
Support
UiPath Community SupportSimilar Listings
Sopra Steria - Format Font Style in Excel
Format font style in Excel cells as Bold, Italic or Underline
8
Bronze Certified
Sopra Steria - Add Cell Borders in Excel
Easily add borders in Excel
2 reviews
40
Bronze Certified
Excel Range to Image
This activity converts the given Excel range into an image along with its cells' format
2 reviews
1k
Bronze Certified
Color Cells with Invalid Special Characters
Reads Input file and colors all the cells which contain any of the special characters except for those which are mentioned in the Array of String
1 reviews
9
Bronze Certified
