429d6b08-7b09-406b-bb91-aa8e87e9fb8a.png

Supercharge your Excel workflows by unlocking the power of automation! 

Experience optimized data processing by automating tasks such as filtering, sorting, merging, and aggregating data. Save valuab

Data Automation in Excel

自動化の力を解き放ち、Excel ワークフローを強化しましょう。

データのフィルタリング、並べ替え、結合、集計などのタスクを自動化することで、最適化されたデータ処理を体験してください。貴重な時間を節約し、生産性を向上させ、完璧なデータ精度を簡単に確保します。

ファイル変換を簡単に合理化し、面倒な手動変換に別れを告げます。データを関係者とシームレスに共有し、好みのシステムやアプリケーションに統合

a6e5b969-be6e-4756-ae53-47d3cb899ca4.png

6968cfdd-77f9-46a8-8c40-7b175a5b0654.nupkg

The activities in this package mimic human actions like GoTo cell, FindAll, GoRight, Left Below Above Last Row etc. It works well on large Excel files as well, and it does not hold any data in memory.

  

This activity can be used to style your Excel sheet/cell: Format Cell (Number, Percentage, Currency etc.), Bold, Fill Color, Font Color, Column Width, Row Height etc.

  

This package is comprised of the following activities:

1.  **Excel Extension Scope**
2.  **Activate Sheet**
3.  **AutoFill**
4.  **AutoFit**
5.  **ChangeFormat**
6.  **ClearContent**
7.  **CloseSession**
8.  **CopyAsPicture**
9.  **DeleteSheet**
10.  **FillColor**
11.  **FindAll**
12.  **FontStyle**
13.  **GetActiveCell**
14.  **GetLastColumn**
15.  **GetLastRow**
16.  **GetSheets**
17.  **GoTo**
18.  **Insert | Delete**
19.  **Merge**
20.  **ReadCell**
21.  **RefreshAll**
22.  **SaveWorkbook**
23.  **SelectRange**
24.  **SetWidthAndHeight**
25.  **SetZoom**
26.  **WriteCell**
27.  **Rename Sheet**

This activities library allows easy integration with Excel. The activities will mimic human actions. It also works with large Excel files.

722d40c8-96a2-43fd-b9d2-807fcb7eb139.PNG

Visual Basic

26a0673b-7c77-4276-ac89-da01a8a4d8ab.pdf

37807f6c-dbb0-4d22-994c-8cd4c608f40a.zip

f2ec6df7-ecc3-482a-b354-fa9c6f47d36a.nupkg

The activities in this package mimic human actions like GoTo cell, FindAll, GoRight, Left Below Above Last Row etc. It works well on large Excel files as well, and it does not hold any data in memory.

  

This activity can be used to style your Excel sheet/cell: Format Cell (Number, Percentage, Currency etc.), Bold, Fill Color, Font Color, Column Width, Row Height etc.

  

This package is comprised of the following activities:

1.  **Excel Extension Scope**
2.  **Activate Sheet**
3.  **AutoFill**
4.  **AutoFit**
5.  **ChangeFormat**
6.  **ClearContent**
7.  **CloseSession**
8.  **CopyAsPicture**
9.  **DeleteSheet**
10.  **FillColor**
11.  **FindAll**
12.  **FontStyle**
13.  **GetActiveCell**
14.  **GetLastColumn**
15.  **GetLastRow**
16.  **GetSheets**
17.  **GoTo**
18.  **Insert | Delete**
19.  **Merge**
20.  **ReadCell**
21.  **RefreshAll**
22.  **SaveWorkbook**
23.  **SelectRange**
24.  **SetWidthAndHeight**
25.  **SetZoom**
26.  **WriteCell**
27.  **Rename Sheet**

**Release 2.0:**

\- Listing is upgraded to work on both .NET 6 (Windows Projects) and also .NET 4.5.1 (Windows-Legacy).

eb7a7c47-0cde-4a68-b085-6238f8dab168.zip

b7dc7347-c127-43df-ad61-0b33341d8512.nupkg

The activities in this package mimic human actions like GoTo cell, FindAll, GoRight, Left Below Above Last Row etc. It works well on large Excel files as well, and it does not hold any data in memory.

  

This activity can be used to style your Excel sheet/cell: Format Cell (Number, Percentage, Currency etc.), Bold, Fill Color, Font Color, Column Width, Row Height etc.

  

This package is comprised of the following activities:

1.  **Excel Extension Scope**
2.  **Activate Sheet**
3.  **AutoFill**
4.  **AutoFit**
5.  **ChangeFormat**
6.  **ClearContent**
7.  **CloseSession**
8.  **CopyAsPicture**
9.  **DeleteSheet**
10.  **FillColor**
11.  **FindAll**
12.  **FontStyle**
13.  **GetActiveCell**
14.  **GetLastColumn**
15.  **GetLastRow**
16.  **GetSheets**
17.  **GoTo**
18.  **Insert | Delete**
19.  **Merge**
20.  **ReadCell**
21.  **RefreshAll**
22.  **SaveWorkbook**
23.  **SelectRange**
24.  **SetWidthAndHeight**
25.  **SetZoom**
26.  **WriteCell**
27.  **Rename Sheet**
28.  **Convert Range to HTML Code**
29.  **Delete Duplicate Columns**
30.  **Delete Empty Columns**
31.  **Delete Empty Rows**

**Release 2.0:**

\- Listing is upgraded to work on both .NET 6 (Windows Projects) and also .NET 4.5.1 (Windows-Legacy).

**Release 2.1:**

\- Four new activities:

*   Convert Range to HTML Code : Converts the Range to the HTML Code
*   Delete Duplicate Columns : Deletes the duplicate columns present in the selected range
*   Delete Empty Columns : Deletes empty columns in the selected range
*   Delete Empty Rows : Deletes empty rows in the selected range

cf0f9cea-eef9-4fcf-bed9-6baeb2cd18be.zip

9cbb9d63-8093-471a-b979-6f368cfe59b1.nupkg

The activities in this package mimic human actions like GoTo cell, FindAll, GoRight, Left Below Above Last Row etc. It works well on large Excel files as well, and it does not hold any data in memory.

This activity can be used to style your Excel sheet/cell: Format Cell (Number, Percentage, Currency etc.), Bold, Fill Color, Font Color, Column Width, Row Height etc.

This package is comprised of the following activities:

1.  **Excel Extension Scope**
2.  **Activate Sheet**
3.  **AutoFill**
4.  **AutoFit**
5.  **ChangeFormat**
6.  **ClearContent**
7.  **CloseSession**
8.  **CopyAsPicture**
9.  **DeleteSheet**
10.  **FillColor**
11.  **FindAll**
12.  **FontStyle**
13.  **GetActiveCell**
14.  **GetLastColumn**
15.  **GetLastRow**
16.  **GetSheets**
17.  **GoTo**
18.  **Insert | Delete**
19.  **Merge**
20.  **ReadCell**
21.  **RefreshAll**
22.  **SaveWorkbook**
23.  **SelectRange**
24.  **SetWidthAndHeight**
25.  **SetZoom**
26.  **WriteCell**
27.  **Rename Sheet**
28.  **Convert Range to HTML Code**
29.  **Delete Duplicate Columns**
30.  **Delete Empty Columns**
31.  **Delete Empty Rows**
32.  **Convert Column To Value** 
33.  **Delete Rows Between Values**
34.  **Delete Columns Between Values**

Version	Release Date	Download Link
2.1.1	November 8, 2024
Three new activities: Convert Column To Value : Removes the formula from the column and retains the value** Delete Rows Between Values : Deletes rows between the given cell values Delete Columns Between Values :** Deletes rows between the given cell values
2.1.0	February 2, 2024
Four new activities: Convert Range to HTML Code : Converts the Range to the HTML Code Delete Duplicate Columns : Deletes the duplicate columns present in the selected range Delete Empty Columns : Deletes empty columns in the selected range Delete Empty Rows : Deletes empty rows in the selected range
2.0.0	November 8, 2023
Upgraded to .NET 6 This package should work in both .NET Framework and .NET 6 or higher.
1.0.7107.42453	March 22, 2019
First Release

Excel Extension Activities