MarketplaceStudioActivityExcel Activities for Processing and Filtering

Create your first automation in just a few minutes.Try Studio Web

Excel Activities for Processing and Filtering

Excel Activities for Processing and Filtering

by Jack Chan

StarStarStarStarStarStarStarStarStarStar

0

Activity

Downloads

3.3k

back button
back button
carouselImage0
next button
next button

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)

Publisher

Jack Chan

Visit publisher's page

License & Privacy

License Agreement

Privacy Terms

Technical

Version

1.0.5

Updated

April 27, 2023

Works with

Studio: 22.10+

Certification

Silver Certified

Application

Microsoft Excel

Support

UiPath Community Support

Resources

Similar Listings