Hi everyone, i’d like to share my new custom activity. Feel free to use it and ask any questions
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 highlight (separated by comma)
e.g. “1,3,5,7,9”
b. In_excelPath (string) – excel path
c. In_sheetName (string) – sheet name
3. Filter Column By Values- filter by multiple critieria
a. in_columnLetterOrNameToFilter (string) - can be the column letter “A”, or the name of the column header “e.g. Heading5”, if you input “Heading5” the robot will find the column where header = “Heading5”
b. In_excelPath (string) – excel path
c. In_sheetName (string) – sheet name
d. In_headerRow (int) – the row where the header is at ( default = 1)
e. in_filterCriteria (String) - values to filter (separated by comma) (<> means not equal to)
Example 1 . AA,AB means filter values = AA,AB
Example 2. <>AA,<>AB means filter values = not AA and not AB

4. Remove Leading Zeroes From Columns
Removes all leading zeroes from text in a column/columns
Inputs
a. in_columnLettersToProcess (string) - the column letters to process (separated by comma)
a. .e.g. “A,B,C”
b. In_excelPath (string) – excel path
c. In_sheetName (string) – sheet name
5. Convert Columns Format To Text
Converts whole column format to text format
Input
a. in_columnLettersToProcess (string) - the column letters to process (separated by comma)
a. .e.g. “A,B,C”
b. In_excelPath (string) – excel path
c. In_sheetName (string) – sheet name
====================================================
Use case - delete all rows where Heading2 = Orange
Steps
- Download my other library AppendRowNumberColumnToDt.Activities (you can find it in the Package Manager)
- Read excel range into variable called “dt”
- Use “Append Row Number Column”
- Loop over dt and add the rowNumber of rows where Heading2=Orange to a list
- Call Batch Delete Rowsactivity In Excel with the list created above