Sign In
Create your first automation in just a few minutes.Try Studio Web →
Excel Activities for Processing and Filtering
by Jack Chan
0
Activity
3.3k
Summary
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, merging and others.
Overview
Overview
This package contains custom activities for row/column processing, and filtering.
Functions include:
1. Batch Delete Rows In Excel - delete specified rows.
2. Batch Highlight Rows In Excel - highlight specified rows.
3: Batch Copy Rows From one excel to another- copy 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.
8. Find values in column range - find string in one or more columns and return the cells found.
9. Find and replace substring in column - find and replace string in a single column.
10. Find column letter of text in row - Returns column letter where the specified string exists in the specified rows.
11. Drag formulas in one or more columns - Drag formulas in one or more columns.
12. Merge Duplicate cells - merge duplicate cells for specified / all columns.
13. Clear Filter - clear filters in a sheet.
Features
Features
These are commonly used functions with many use cases in RPA Excel processing. Use these reusable activities to speed up development time and increase efficiency.
Additional Information
Additional Information
Dependencies
UiPath.Excel.Activities 2.12.3 UiPath.System.Activities 22.4.4
Code Language
Visual Basic
Runtime
Windows (.Net 5.0 or higher)
Technical
Version
1.0.5Updated
April 27, 2023Works with
Studio: 22.10+
Certification
Silver Certified
Application
Support
UiPath Community Support
Resources
Similar Listings