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.

バージョン	リリース日	ダウンロードリンク
1.0.5	2022年9月9日
Recompiled using modern framework
1.0.4	2022年5月3日
Added 1. Merge duplicate cells 2. Clear filters
1.0.3	2022年1月27日
Added 1. Drag Formulas 2. Find column letter of text in row
1.0.2	2021年11月1日
Added 1. Find and replace string in column 2. Find string in column range and return cells
1.0.1	2021年9月27日
Added BatchCopyRowsFromOneExcelToAnother
1.0.0	2021年7月7日
Initial

Excel Activities for Processing and Filtering