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 ワークフローを強化しましょう。

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

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

b900108b-d194-48f9-b24c-e8a3981d6581.png

Senior Consultant

4449a165-4437-406c-8e13-4ba41678b88f.nupkg

This package contains more than 30 custom activities that can be applied to any Workbook, Worksheet, and Sheet data. All the components can be easily configured as they are created in a user-friendly manner.

Below you can find details about some of the activities:

  

*   **Pie, Column, Line, Bar** charts for the excel data Generate different chart types
*   **Rename Work Sheet** - Update the worksheet name
*   **Hide/Unhide** Apply a hide/unhide command to a sheet
*   **Column Hide/Unhide** Apply a hide/unhide command to a column
*   **Row Hide/Unhide** Apply a hide/unhide command to a row Copy Data 
*   **Copy data to Clipboard**. After the information is copied you will be able to paste it  herever you need it.
*   **Clipboard To Datatable** Convert Clipboard data to a data table
*   **Delete Data** Delete or Clear data from a specified sheet range
*   **Merge Cells** Combine multiple adjacent cells into a single larger cell
*   **Unmerge Cells** Change a merged cell back into standard cells
*   **Comment Activities** Add, delete, get, show and hide comments in specific cell
*   **Add/Delete Sheet** Add or delete new sheet to the existing workbook
*   **Change Cell Type** Change the cell range data type like (number and date ....etc )
*   **Export WorkBook** Using this activity can save as pdf
*   **Extract Graph Image** Extract all the graph save as images
*   **AutoFit Columns**
*   **AutoFit Rows**
*   **Copy To File**
*   **Delete Sheet**
*   **Find Replace**
*   **Format Cells**
*   **HyperlinkAdd**
*   **InsertImage**
*   **InsertImageAtCell**
*   **InsertTableFormat**
*   **RemoveDuplicates**
*   **RemoveHyperlink**
*   **AddSheet**
*   **CopyToWorkBook**
*   **CreateWorkBook**
*   **ExportWorkBook**
*   **GetSheetsName**
*   **ProtectUnProtectSheet**
*   **SetPassword**
*   **Set (Change ) Table format**

A playlist containing 9 videos describing how the above activities work is available [here](https://www.youtube.com/watch?v=Z8_7P_rYXIU&list=PLf3RLhpy4LJBfGRCjUJASRZAjdF5DZ5No).

  

In the **Resources Tab** I have attached the details of all the components in the document (**Guide.docx**).

This package consists of multiple Custom Activities that simplify processes in Excel

31853138-57ee-43ce-b5d5-97406b887fd2.png

c53d9968-41c7-41a9-a01d-398ea2c39a8e.png

68f845f0-bb6d-4d6d-81fa-55b611e10bbb.png

MIT License Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the 'Software'), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions: The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED 'AS IS', WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.

Visual Basic

091e4937-0517-43b3-b943-e6deb5412a13.docx

65b7351b-62ee-4a36-9e6b-a3731e6865de.docx

0026992a-d7de-4bb9-a488-ea593827113f.zip

d8cbee14-3660-43f3-9c47-d935e233f02f.nupkg

b0188138-baac-49e3-b829-0ce8148c3fe3.zip

e5c6c582-651b-43dd-a768-122ae67ea870.nupkg

566163db-9ba5-418e-ace5-19c819753374.zip

17a5302e-2417-4259-90d3-5964ae99eede.nupkg

17711660-2057-4f6a-ac8e-840b63677422.zip

c3aed980-7034-44c7-9282-3415bb6ba8b6.nupkg

d206c25e-3cdd-4848-8d11-ead4ab109e5a.zip

ca408af0-a90c-4cea-b928-b63e5e337bd0.nupkg

3bb8feee-a283-4565-8755-7e6bd2149449.zip

b26f23bd-20b3-4495-9375-0feaf95f8004.nupkg

b515dc2d-4bf8-468e-83d9-0a2a34bfa0f7.zip

134a427f-2060-4d9a-9429-f880a6d2b803.nupkg

9f7a6f2b-672b-4e2a-b4ef-8f1c192349c0.zip

5f788e76-9144-46ca-a43e-8914ed37f4bc.nupkg

759700a6-49f3-4456-bad2-7f47e3094000.zip

b96d2167-88ce-43e5-a90f-1fc63781a4c0.nupkg

7145641b-4067-4b3e-ba2a-d9c85ea4135a.zip

6838679d-ca64-45f7-b6f7-f3da960ed31b.nupkg

6519ad28-8d5e-481b-b715-0c1b6f9dc1fd.zip

439a7a8e-d5b8-44d6-9c7c-182ea3ec50ca.nupkg

f3c6c78f-54a2-4729-94f8-89b4bedd7b8a.png

This package contains more than 30 activities that can be applied to any Workbook, Worksheet, and Sheet data. All the components can be easily configured as they are created in a user-friendly manner.

  

For the advanced, Gold certified and supported version of this package, please visit **BalaReva - Excel Automation for Enterprises**: https://marketplace.uipath.com/listings/3124.

  

Below you can find details about some of the activities:

*   **Pie, Column, Line, Bar** charts for the Excel data generate different chart types.
*   **Rename Work Sheet** - Update the worksheet name.
*   **Hide/Unhide -** Apply a hide/unhide command to a sheet.
*   **Column Hide/Unhide** - Apply a hide/unhide command to a column.
*   **Row Hide/Unhide** - Apply a hide/unhide command to a row Copy Data. 
*   **Copy data to Clipboard** \- After the information is copied you will be able to paste it wherever you need it.
*   **Clipboard To Datatable -** Convert Clipboard data to a data table.
*   **Delete Data** - Delete or Clear data from a specified sheet range.
*   **Merge Cells** \- Combine multiple adjacent cells into a single larger cell.
*   **Unmerge Cells** - Change a merged cell back into standard cells.
*   **Comment Activities** \- Add, delete, get, show and hide comments in specific cell.
*   **Add/Delete Sheet** \- Add or delete new sheet to the existing workbook.
*   **Change Cell Type** - Change the cell range data type like (number and date ....etc ).
*   **Export WorkBook** - Using this activity can save as PDF. 
*   **Extract Graph Image** - Extract all the graph  and save as images.
*   **AutoFit Columns**
*   **AutoFit Rows**
*   **Copy To File**
*   **Delete Sheet**
*   **Find Replace**
*   **Format Cells**
*   **HyperlinkAdd**
*   **InsertImage**
*   **InsertImageAtCell**
*   **InsertTableFormat**
*   **RemoveDuplicates**
*   **RemoveHyperlink**
*   **AddSheet**
*   **CopyToWorkBook**
*   **CreateWorkBook**
*   **ExportWorkBook**
*   **GetSheetsName**
*   **ProtectUnProtectSheet**
*   **SetPassword**
*   **Set (Change ) Table format**

  

In the **Resources Tab** I have attached the details of all the components in the document (**Guide.docx**).

This package consists of multiple activities that simplify processes in Excel.

4d56c06a-dee5-4674-99c4-fc3ebced5e84.zip

f255dd1e-d0ee-4120-8229-ce555a3c874a.nupkg

This package contains more than **30 activities** that can be applied to any Workbook, Worksheet, and Sheet. All the components can be easily configured as they are created in a user-friendly manner.

  

For the advanced, Gold certified and supported version of this package, please visit **BalaReva - Excel Automation for Enterprises**: https://marketplace.uipath.com/listings/3124.

  

Below you can find more details about some of the activities:

*   **Pie, Column, Line, Bar** charts for Excel data - Generate different chart types.
*   **Rename Work Sheet** - Update the worksheet name.
*   **Hide/Unhide -** Apply a hide/unhide command to a sheet.
*   **Column Hide/Unhide** - Apply a hide/unhide command to a column.
*   **Row Hide/Unhide** - Apply a hide/unhide command to a row. 
*   **Copy data to Clipboard** \- After the information is copied you will be able to paste it wherever you need it.
*   **Clipboard To Datatable -** Convert Clipboard data to a DataTable.
*   **Delete Data** - Delete or Clear data from a specified sheet range.
*   **Merge Cells** \- Combine multiple adjacent cells into a single larger cell.
*   **Unmerge Cells** - Change a merged cell back into standard cells.
*   **Comment Activities** \- Add, delete, get, show and hide comments in specific cell.
*   **Add/Delete Sheet** \- Add or delete new sheet to the existing workbook.
*   **Change Cell Type** - Change the cell range data type like (number and date ....etc ).
*   **Export WorkBook** - Save the file as PDF. 
*   **Extract Graph Image** - Extract all the graphs and save as images.
*   **AutoFit Columns -** Auto fit the column with adjusted with text.
*   **AutoFit Rows -** Auto fit the row height with multiple lines.
*   **Copy To File**
*   **Delete Sheet**
*   **Find Replace**
*   **Format Cells**
*   **HyperlinkAdd**
*   **InsertImage**
*   **InsertImageAtCell**
*   **InsertTableFormat**
*   **RemoveDuplicates**
*   **RemoveHyperlink**
*   **AddSheet**
*   **CopyToWorkBook**
*   **CreateWorkBook**
*   **ExportWorkBook**
*   **GetSheetsName**
*   **ProtectUnProtectSheet**
*   **SetPassword**
*   **Set (Change) Table format**

  

Please check the **Resources Tab** for more details about the activities.

8854889d-b097-4c08-8205-47c568023282.docx

e69587c8-9f00-4a02-9245-ded169f25212.docx

38483efa-af99-43f5-82f4-5f8a861c7901.zip

BalaReva Excel Activities