MarketplaceListingsCustom ActivityExcel Activities for Processing and Filtering

Excel Activities for Processing and Filtering

Bronze Certified

Custom Activity

0 reviews

18

Excel Activities for Processing and Filtering

Bronze Certified

Custom Activity

0 reviews

18


Summary

Contains commonly used Excel activities for row/column processing, and filtering. For example batch row delete, batch row highlight, convert column format to text, filtering etc.

carouselImage0

Overview

Contains custom activities for row/column processing, and filtering. For example batch row delete, batch row highlight, convert column format to text, filtering etc.

Functions include:
1. Batch Delete Rows In Excel - delete specified rows
2. Batch Highlight Rows In Excel - highlight specified rows
3. Filter Column By Values - filter by multiple critieria
4. Convert Column Format To Text
5. Remote Leading Zeroes From Column - remove all leading zeros from a column e.g. 0000123 to 123
6. LetterToExcelColumnNumber - convert letter to number e.g. A to 0, AA to 26 etc
7. NumberToExcelColumnLetter - convert number to letter e.g. 0 to A, 26 to AA etc.

Benefits

These are commonly used functions with many use cases in RPA Excel processing. Use these reusable components to speed up development time and increase efficiency.

Published: 07 Jul 2021 | Updated: 15 Jun 2021

Jack Chan
RPA Developer

License

By clicking download you agree to the following license.


Code Language

Visual Basic


Runtime

.NET Core


Tags

batch-delete
batch-highlight
Delete Rows
filter
highlight-rows

Compatibility

Studio: 2020.4.3 - 2021.4.4


Dependencies

UiPath.excel.activities 2.10.4 UiPath.system.activities 21.4.1


Documentation


Similar Listings