af0f72e4-3c87-4f18-a66e-30e1016fd3d4.nupkg

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\. **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.

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 etc.

b63ad7c8-acf6-48b6-9b6c-bf40a5aa1c64.png

Visual Basic

ebbad646-4859-45cb-95ee-f04c0faaa9f5.pdf

054e6b90-0bcd-4653-b84b-f8acf34b2635.zip

a44b1a97-dab1-40aa-aadf-10cd8c3a4f46.nupkg

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.

015ea553-4c4f-4464-adb6-c5307ccfa8f3.png

21ef2594-a435-4828-80d8-3a45d8236915.pdf

f33fdaea-96f0-41be-9099-b2fca91c30bd.zip

d3552120-15ef-4ff6-8fda-6bfbeff7c365.nupkg

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.

  

_**New in 1.0.2**_

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.

0f731813-6943-4462-b10c-9a681bde0ea4.png

63e7530a-1a17-4fd5-a652-7433322b914b.pdf

33c27618-5361-4cc1-841c-5af27735f867.zip

f65cda62-3440-4aca-bde9-fb1b79e3fb39.nupkg

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.

  

_**New in 1.0.3**_

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.

6c51fc30-d430-4d44-a66f-9e3311836668.png

7f2e3fbb-0060-4526-9ffc-901280c7f8a1.pdf

ecd5db26-45f3-4f00-a1c1-cdf747aca560.zip

9451ca0e-c38f-4c58-9289-8a4797ffaf68.nupkg

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.

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.

2fd2d315-b6c5-4818-913f-fb74fde074eb.png

53f7b020-04ce-4523-a1e3-1f9dff919c43.pdf

3af27c53-1701-4b80-847c-4a2d26fb357c.zip

3d9984e2-717d-46ea-bac8-85bf745fec8d.nupkg

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.

Excel Activities for Processing and Filtering