Excel Activities for Processing and Filtering v1.4

[jack.chan]

Hi everyone, i’d like to share the new version to my custom activity. Feel free to use it and ask any questions

Excel Activities for Processing and Filtering - RPA Component | UiPath...

for v1.0,1.1 thread :

Excel Activities for Processing and Filtering

Hi everyone, i’d like to share my new custom activity. Feel free to use it and ask any questions [image] Main Functions include: 1. Batch Delete Rows In Excel - delete specified rows Inputs a. In_rowNumbersToDelete (string) - the row numbers to delete (separated by comma) a. .e.g. “1,3,5,7,9” b. In_excelPath (string) – excel path c. In_sheetName (string) – sheet name 2. Batch Highlight Rows In Excel - highlight specified rows a. In_rowNumbersToHighlight (string) - the row numbers to …

v1.2

Excel Activities for Processing and Filtering v1.2

Hello @jack.chan! It seems that you have trouble getting an answer to your question in the first 24 hours. Let us give you a few hints and helpful links. First, make sure you browsed through our Forum FAQ Beginner’s Guide. It will teach you what should be included in your topic. You can check out some of our resources directly, see below: Always search first. It is the best way to quickly find your answer. Check out the [image] icon for that. Clicking the options button will let you set …

v1.3

Excel Activities for Processing and Filtering v1.3

Hi everyone, i’d like to share the NEW version to my custom activity. Feel free to use it and ask any questions for v1.0,1.1 thread : v1.2 v1.3 functions 1. Find column letter of text in row - Returns column letter where the specified string exists in the specified rows. Input in_excelPath – excel path in_rowNumberToSearch – the row number you want to search in in_SheetName - sheet in_textToSearch – the text you want to search for Output found column Letter [image] 2. Drag formu…

v1.4 functions

1. Merge Duplicate cells - merge duplicate cells for specified / all columns.
2. Clear Filter - clear filters in a sheet.

Merge Duplicate cells
Inputs:

1. sheetName = sheet
2. excelPath = excel path
3. in_columnLetterListString:
   a. Columns to process
   i. e.g. “A,B,C” will merge duplicates cells in columns A,B,C in given row
   ii. e.g. “” (blank) will merge cells in ALL columns of given row
4. in_headerRowNumber- Row number of header (default “1”)

[Nithinkrishna]

Hey @jack.chan

Demanding info, worth shared.

Thanks
#nK

[Nithin_P (Nithin Prabhu)]

Good Share @jack.chan !!

[jack.chan]

Update (1.0.5)

Recompiled using MODERN FRAMEWORK

https://marketplace.uipath.com/auth/refresh-session?url=/listings/jack-excel-functions-activities