MarketplaceListingsCustom ActivityExcel Activities for Processing and Filtering

Excel Activities for Processing and Filtering

by Jack Chan

0

1k

Excel Activities for Processing and Filtering

by Jack Chan

0

Custom Activity

1k

carouselImage0

Summary

Summary


Overview

Overview

This package 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: 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.

New in 1.0.4
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 components to speed up development time and increase efficiency.

Additional Information

Additional Information

Dependencies


Code Language

Visual Basic

Runtime

Windows (.Net 5.0 or higher)

Publisher

Jack Chan

Visit Publisher's Page

Technical

Version

1.0.4

Updated

03 May 2022

Certification

Silver Certified

Tags

batch-delete
batch-highlight
Delete Rows
filter
batch-copy

Application

Microsoft Excel

Support

UiPath Community Support

Resources

Similar Listings