Explore a new era of automation with UiPath agent templates, designed to streamline your processes and boost productivity. 

UiPath Agent Templates 

This collection helps expedite manual operations by integrating automations for personal productivity, cross-team collaboration, project and task management, customer relationship management.

Autopilot for everyone Automations

Embrace Generative AI-powered automations to revolutionize your business operations. Drive strategic insights propelling your organization to new heights of success.

Leverage Generative AI to Amplify Automation

Explore industry-specific Solution Accelerators automating complex data tasks for accuracy and efficiency across sectors.

Enhance Data Extraction with UiPath Document Processing

Step into the world of effortless automation with UiPath Studio Web, your web-based automation canvas.

Studio Web Templates

5bf65208-3184-4d69-8bd2-4d39bb56d468.png

UiPath use case accelerators are automation frameworks which are custom-built for specific use cases. These frameworks use best practices and pre-built components which can be modified, expanded, and 

Solution Accelerators

This collection offers tailored solutions for various industries. Customizable to your needs, these accelerators reduce manual tasks, boosting customer focus.

Let Generative AI Drive Day-to-Day Process Automation

These accelerators tackle claims processing pain points, ensuring faster turnarounds, higher accuracy, and superior customer service.

Accelerate Claims Processing with Intelligent OCR

5ac26976-207d-4570-87af-93679ff1f0d1.png

Discover the power of AI in breaking down language barriers, streamlining repetitive tasks, and automating data extraction.

Artificial Intelligence 

UiPath Integration Service seamlessly combines user interface (UI) and API automation.

UiPath Integration Service Connectors

3fd781a1-c521-43bb-bc29-d01a548f47e4.png

Dive into the world of advanced chatbots and virtual assistants to enhance customer interactions, streamline support, and drive engagement.

Conversational AI

2b43585f-c31b-4fb9-a605-7e94f58c92ae.png

Easily configurable utilities for SAP interaction using BAPI, UiAutomation and SAP Scripting. Whether it's login, registration or grid operations, ensure speed & security with regularly updated packs.

BAPI、UiAutomation、SAP Scripting を使用した SAP 対話用の簡単に構成可能なユーティリティ。ログイン、登録、グリッド操作のいずれであっても、定期的に更新されるパックで速度とセキュリティを確保します。

f894dcd0-fa35-43b6-99a3-4dd1375eeeba.png

UiPath Process Mining provides out-of-the-box application templates for various processes and source systems, serving as a foundation for creating customized process apps to visualize your data.

UiPath Process Mining App Templates

Discover the transformative power of Intelligent Document Processing, an all-inclusive suite of cutting-edge tools, advanced technologies, and AI models seamlessly integrated with UiPath. 

Intelligent Document Processing

75675453-6287-4681-9033-6924c7cd592d.png

Automate scheduling and routine tasks to optimize collaboration and enhance efficiency.

Meeting Management

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

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

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

522a48a8-6da0-4664-9ab5-5287724c927f.png

Unlock the unparalleled synergy of advanced technologies and seamless teamwork in the cloud.

Explore the remarkable capabilities of Microsoft Office 365, and empower your team with the comprehensive 

360° Cloud Collaboration

クラウドでの先進テクノロジーとシームレスなチームワークの比類のない相乗効果を解き放ちます。

Microsoft Office 365 の優れた機能を探索し、Office アプリケーションの包括的なスイートでチームを強化し、あらゆるデバイス間での楽なコラボレーション、シームレスなドキュメント共有、および合理化されたコミュニケーションを促進します。

Google Cloud Platform がも

3e9d5444-052e-459f-bb19-907e7e0e4433.png

Seamlessly blend the power of automation with the most popular communication tools of today. Elevate your business efficiency and enhance collaboration with some of the most popular applications avail

Chat and Video Conferencing

自動化の力と、今日最も人気のあるコミュニケーション ツールをシームレスに融合します。 Slack、Zoom、Teams、Kaizala などの最も人気のあるアプリケーションを使用して、ビジネスの効率を高め、コラボレーションを強化します。

日常的なタスクを自動化し、情報を簡単に共有し、チームの生産性を向上させ、グローバルなコラボレーションを促進し、言語の壁を打ち破り、ビデオ会議の包括性を高めます。

cbbc6b4e-f074-4845-bae9-d566ce849604.png

Simplify your email-related tasks with these automations designed to enhance your productivity and efficiency. 

Seamlessly integrate with Microsoft Exchange and unlock a world of possibilities. Maxim

Email Management

生産性と効率性を高めるために設計されたこれらの自動化機能を使用して、電子メール関連のタスクを簡素化します。

Microsoft Exchange とシームレスに統合し、可能性の世界を解き放ちます。電子メールの自動化機能を最大限に活用し、メールボックスを管理し、Exchange サーバーと簡単に対話します。

Outlook エクスペリエンスをコントロールし、メール管理に革命をもたらします。電子メ

b4800617-33aa-4b32-a55b-25e1baebe6e6.png

UiPath’s vision for the “Automation First” era has led to the addition in its market-leading Enterprise RPA Platform of dedicated official out-of-the-box IT Automation capabilities that empower all co

IT Automation

2ce7d800-9fc2-4ae6-8d87-f0cf8e113183.png

The Efficient Operations Management collection offers a carefully curated selection of automations tailored to boost efficiency, minimize manual effort, and guarantee seamless management of essential 

Efficient Operations Management 

Efficient Operations Management コレクションは、効率を高め、手作業を最小限に抑え、重要な運用のシームレスな管理を保証するためにカスタマイズされた自動化の厳選されたセレクションを提供します。

これらの自動化を活用すると、さまざまな可能性が広がります。たとえば、IBM Operational Decision Manager の機能を利用して意思決定プロセスを自動化お

dcb8ac57-00fd-4a07-bb11-46d33a557e4a.png

Enhance your document collaboration and revolutionize your workflows by seamlessly integrating powerful applications such as Microsoft 365, Adobe, and Dropbox to streamline your document management pr

Intelligent Document Collaboration 

Microsoft 365、Adobe、Dropbox などの強力なアプリケーションをシームレスに統合してドキュメント管理プロセスを合理化することで、ドキュメントのコラボレーションを強化し、ワークフローに革命をもたらします。

Excel ファイルから直接ドキュメント作成を自動化することで、貴重な時間と労力を節約します。自動生成の利便性を享受しながら、ドキュメント全体の正確さと一貫性を確保します。

7fd9787d-6676-408b-9f09-24ff7aa06fc1.png

Whether you're a professional, student, or busy individual, this collection offers a range of automations to simplify your everyday tasks.

From automating the creation of presentations and documents 

User-Friendly Automation Toolbox

専門家、学生、または忙しい個人であっても、このコレクションは日常業務を簡素化するためのさまざまな自動化を提供します。

Excel ファイルに基づくプレゼンテーションやドキュメントの作成の自動化から、Mac での通貨サンプルの変換まで、このコレクションは幅広いニーズをカバーします。ドキュメントを簡単に印刷する必要がありますか?ご対応させていただきます。システムのシャットダウンを設定したり、フラッシ

5011f5c1-f0e5-46ce-9d75-fde641620343.png

Get the best of both worlds - the power of UiPath and the expertise of our partners. Our hand-picked partner network offers a wide range of professional services to enhance your automation journey wit

Professional Services

e58153e6-c384-40f1-9a04-b74d92d4b7b2.png

Unlock a world of enhanced capabilities, empowering you to seamlessly interact with PDF forms, extract specific pages, ensure the integrity of your PDF files, compare documents for differences, and ex

PDF Automation

強化された機能の世界を解放し、PDF フォームのシームレスな操作、特定のページの抽出、PDF ファイルの整合性の確保、ドキュメントの相違点の比較、および多数の PDF 処理タスクの実行を可能にします。

a235052e-07e6-4500-b3a8-049dca38cb98.png

Elevate your UiPath projects, and unlock unparalleled efficiency, scalability, and security. From building intelligent bots to automating document processing and performing advanced text analysis, to 

Popular Demand

UiPath プロジェクトを強化し、比類のない効率、拡張性、セキュリティを解放します。インテリジェントなボットの構築から文書処理の自動化、高度なテキスト分析の実行、自然言語処理と生成の組み込みまで、自動化への取り組みに革命をもたらし、生産性を向上させます。

c0458317-142d-43d2-bbdb-f4a5ccee3aa8.png

Experience blazing-fast document processing, take control of your workflows with seamless task and process management, say goodbye to the struggle of matching invoices and payments, gain comprehensive

New Arrivals

すべて自動化の助けを借りて、超高速のドキュメント処理を体験し、シームレスなタスクとプロセス管理でワークフローを制御し、請求書と支払いを照合する苦労に別れを告げ、ライセンスの使用状況に関する包括的な洞察を得ることができます。

a968734e-736c-4c12-894d-0f60043e2609.png

Tired of spending countless hours manually converting documents between different formats? Whether you need to convert a Word file to PDF, HTML, TXT, or even XML, these automations have got you covere

Document Format Conversion

ドキュメントを異なる形式間で手動で変換するのに膨大な時間を費やすことにうんざりしていませんか? Word ファイルを PDF、HTML、TXT、さらには XML に変換する必要がある場合でも、これらの自動化機能が役に立ちます。コンテンツをコピー＆ペーストしたり、フォーマットの問題に苦労したりして貴重な時間を無駄にする必要はもうありません。希望の出力形式を選択し、あとは自動化に任せるだけです。

cc4e1f9f-ee63-4465-ade4-76e04dcd5f13.png

Simplify and optimize the flow of structured data within your organization with the help of activities like data transformation, validation, comparisons. By automating these tasks, data can be streaml

Structured Data Streamlining

データ変換、検証、比較などのアクティビティを利用して、組織内の構造化データのフローを簡素化し、最適化します。これらのタスクを自動化することで、データを合理化、標準化し、アクセスしやすくすることができ、効率的なデータ分析、レポート作成、意思決定のプロセスにつながります。

自動化ツールと技術を活用して、大量のデータを管理および処理するための体系的なアプローチのメリットを活用します。手動作業を削減して

Simplify your data management processes and unlock new levels of efficiency.

Text-Based Tabular Data Manipulations

Discover automations designed to revolutionize how you monitor and optimize the performance of your processes. 

Utilization Reporting and Monitoring

Transform your data into compelling visual representations, saving time and effort while delivering impactful insights.

Automated Charting and Graphing

Integrate automation into your workflows, and witness the transformative impact on your communication strategies.

Text Message Automation and Management

Unlock unparalleled task optimization and efficiency with our collection designed to streamline your workflow and supercharge productivity.

Task Optimization and Efficiency

Unlock the potential of your file management with this comprehensive collection designed to streamline workflows and optimize organization. 

File Organization and Control

Unlock the boundless potential of image processing and revolutionize your automation workflows with our exceptional collection. 

Image Processing

Experience the power of Automated Testing Frameworks collection, and revolutionize your software testing endeavors.

Automated Testing Frameworks

Revolutionize workflows with an automated suite for optimized processes and efficiency. Innovate password operations, enhance user experience, and streamline access management effortlessly.

Authentication Enhancers

With a focus on streamlining your IT operations and enhancing productivity, this collection offers a range of powerful features to elevate your organization's performance.

Office IT Workflows Automation

Explore the Language Translation collection, designed to expedite and enrich language translation processes.

Language Translation

Whether you're a seasoned globetrotter or planning your dream getaway, this collection will revolutionize the way you organize, plan, and enjoy your travels.

Travel and Vacation Planning

Whether you're looking to automate file transfers, synchronize data across multiple platforms, or manage cloud storage efficiently, this collection has you covered.

Online Storage and Sharing

Unlock the full potential of your automation projects today and revolutionize the way you handle string manipulation tasks.

String Manipulation

Experience simplified wage and tax statement processing, enabling swift generation and management of essential documents while adhering to regulatory standards.

Tax and Compliance Processing

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 valuable time, boost productivity, and ensure impeccable data accuracy with ease.

Streamline file conversion effortlessly and say goodbye to tedious manual conversions. Share data seamlessly with stakeholders and integrate it into your preferred systems or applications.

Handle massive datasets and extract valuable insights from spreadsheets containing millions of rows and columns without compromising performance. Analyze and report on vast volumes of data with precision and speed.

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

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

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

パフォーマンスを損なうことなく、大規模なデータセットを処理し、数百万の行と列を含むスプレッドシートから貴重な洞察を抽出します。膨大な量のデータを正確かつ迅速に分析してレポートします。

2b851117-37ac-41f7-aefc-7b597d05acb2.png

This package contains activities that provide extension to some of the basic UiPath activities - create/save/copy/modify files and read/cleanse/transform/visualize/write data from these files. These activities provide various other Microsoft Excel features - to name a few i) pivot table operation, ii) data lookup, iii) data manipulation using formulas and macros, iv) update file with with password, v) format data.

This WonderBotz package contains activities that perform various data transformation and visualization operations using Microsoft Excel and Power Query.

a1eb5d6b-141f-43b2-b2b1-1e4978f63789.png

This activity pack is designed to help RPA developers and business users speed up MS Excel and Power Query-related automation. It offers an extension to some of the official UiPath activities such as:

*   Interaction with Pivot Tables
*   Data Lookups
*   Data Manipulation
*   Add formulas to excel rows & columns
*   Add passwords to sheets or workbooks
*   Format data with fonts, tables, etc.
*   All actions that are not possible without opening excel files

Automates processes consisting of Microsoft Excel and Power Query faster with fundamental data transformation and visualization operations.

This activity pack is designed to help RPA developers and business users speed up MS Excel and Power Query-related automation. It offers an extension to some of the official UiPath activities such as:

*   Interaction with Pivot Tables
*   Data Lookups
*   Data Manipulation
*   Add formulas to Excel rows & columns
*   Add passwords to sheets or workbooks
*   Format data with fonts, tables, etc.
*   All actions that are not possible without opening Excel files

Extraordinary People and Services for Extraordinary Companies. Ubiquity Technology is a Europe based company **integrating people, business** and **technology**. We **innovate** using technology to **optimize** our clients businesses. **Commitment** is our way.

9d4ed81a-7488-47ec-8b27-1ef766ca827c.png

This component is based on the ASCII table, if the number received is 2 it will return B.

  

**Use case:**

  

Imagine this scenario: you have a large Excel file and you know that one of the fields that you need in your DataTable is in the index 208. You need to write in the Excel file with the activity WriteCell and you need the correct coordinate. You just need to include this activity, pass the index and you will get HA as your Excel coordinate to write in the correct cell.

As an option, you can use column number instead, just remember that the index is zero based.

This activity receives as input the column number index and converts it to column letter (uppercase).

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

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.

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.

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

An activities pack that converts files between various formats.

  

It receives as parameters the file path of the original file, the path of the folder where the new file should be created and the name of the new converted file.

  

Currently, the package contains the following activities:

*   Convert DOC to DOCX
*   Convert DOCX to DOC
*   Convert Word to PDF
*   Convert XLS to XLSX
*   Convert XLSX to XLS

**Input**

*   **FilePath(string)** **\-** path of the file that we're going to convert.
*   **Directory To Save In(string**) **\-** path of the folder where we're going to save the new file.
*   **New File Name(string)** **\-** the name of the newly created file.

**Output**

*   **Resulting FilePath (string)** **\-** file path of the newly created file.

**How To Use**

Example - Convert XLS to XLSX:

First, we input the full file path for the .xls file, we specify the destination folder and the name of the new file.

Then, we proceed to read and process the file as normal.

The resulting file will be "C:\\UiPath\\ResultXLSX.xslx".

  

**Observation and limitations:**

*   Because of the usage of COM Interop, it means that this activity requires that the Office application is installed to successfully convert the file.
*   It is possible that converting XLS and/or Word files will not work for extremely large files.

This custom activity converts Excel and Word files using the COM Interop library.

**Objectives:**

*   Providing a robust and facile manner of processing very large Excel files in the background and without relying on COM Interop.
*   The implementation of these custom activities will give the user the last row of the Excel file (extremely useful when trying to process a file in chunks). Currently trying to read a file in chunks is impossible without knowing the number of rows and columns in the sheet.
*   The implementation of an Application Scope activity that will allow the grouping of the custom activities in this package.
*   Providing activities that are similar in structure and type of parameters to the current Excel application.

**Observation and limitations:**

  
The activity will not keep track of the formats used to display values in the Excel application. For example, a cell with a value of 43006 formatted as date will be displayed as 9/28/2017 in Excel, but this activity will still retrieve it as 43006.  

Files in which the row starts with the index 0 (this index can be found in the XML mark-up of the row) will not be processed. The row number also needs to be under 1048576 (the maximum number of rows in an Excel Sheet). If a row number outside of this interval is found, the application will throw an exception. This limitation is also valid for the Read Range in the Workbook activities package.  

This package is not compatible with .xls files or .csv files. Only .xlsx files can be read with this activity. Reading Large XLS files can be done in conjunction with the Conversions Package, which will convert the file to an .xlsx file, thus making it compatible with this package.  

Some very minor differences when deciding where a range ends between the standard Excel processing activities and this one.

  

**Technical Approach:**  

The files will be processed in the background using the Open XML SDK library and the SAX (Simple API for XML) approach which instead of reading the entire document and exposing its DOM, will independently read the XML files that comprise the Excel document.

  

**Read Range**

  

**Principles**

  

This custom activity reads a Range of cells from an Excel Sheet. It achieves its goal by using the Open XML SDK framework and the OpenXmlReader class to parse the File in a SAX like approach. To get the number of rows, we simply parse the file and count the rows.  

The custom activity is created by simply inheriting the CodeActivity class from the Windows Workflow Foundation framework. We define the logic of the function by implementing the Execute method and we define the input and output of the activity by fields of the InArgument and OutArgument types.  

This activity can only be placed inside a XL Excel Application Scope activity (not necessarily directly inside, but one of its parents must be the XL Excel Application Scope).

An activity pack used to read and process extra large Excel files.

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.

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

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

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

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**
35.  **Set Color For Header**
36.  **Unmerge Cells In Sheet**

We were founded in 2005 in a tiny apartment in Bucharest, Romania as DeskOver.

Fittingly, it was a customer who, in 2012, first saw the immense possibilities for us in the fledgling RPA market. Our desktop automation product launched in 2013. In 2015, we introduced our enterprise platform along with our new name.

Today, UiPath is the fastest-growing enterprise software company in history with scores of offices, thousands of employees, partnerships with the world’s best consulting and BPO firms, a **500,000-strong developer community**, and **5MM+ robots at work** in over **5,000 global enterprises.**

Our mission is to deliver the leading Robotic Process Automation platform to our clients for an automation first mindset.

We build software robots that automate repetitive processes. Our software robots take on the tedious, mind-numbing work and free people to do the more stimulating, creative work worth doing.

But no matter how much we’ve grown, one thing hasn’t changed. We’re still building a company we love to work for

22ac2b39-8e69-4be8-8c56-879cf6d99177.png

The Create documents based on my Excel file automation allows you to quickly generate multiple documents using data from an Excel template. It takes the data from the Excel template and creates a Word document for each row in the template. This automation is great for creating personalized files, populating reports, or preparing meeting documents.

This automation creates Word documents from a template using information from an Excel file.

The Create documents based on my Excel file automation allows you to quickly generate multiple documents using data from an Excel template. It takes the data from the Excel template and creates a Word document for each row in the template. 

  

This automation is great for creating personalized files, populating reports, or preparing meeting documents.

  

Beginning with version 2.2.0, we have migrated this automation to Windows (.Net 5.0 or higher) project.

If you need the Windows-Legacy project version, please download version 2.1.0.

The Protect and Unprotect My Excel Workbook automation allows you to quickly password-protect Excel workbooks from editing or remove an existing password from the Excel workbooks. It processes a folder of Excel workbooks and protects or unprotects them based on the operation you’ve chosen. The automation is great for protecting confidential reports, removing passwords from shared workbooks, or batch protecting/unprotecting all your files.

This automation protects Excel workbooks with a password or unprotects them using the designated password.

The Protect and Unprotect My Excel Workbook automation allows you to quickly password-protect Excel workbooks from editing or remove an existing password from the Excel workbooks. It can process a single workbook or a folder of Excel workbooks and protects or unprotects them based on the operation you’ve chosen. The automation is great for protecting confidential reports, removing passwords from shared workbooks, or batch protecting/unprotecting all your files.

The Protect and Unprotect My Excel Workbook automation allows you to quickly password-protect Excel workbooks from editing or remove an existing password from the Excel workbooks. It can process a single workbook or a folder of Excel workbooks and protects or unprotects them based on the operation you’ve chosen. The automation is great for protecting confidential reports, removing passwords from shared workbooks, or batch protecting/unprotecting all your files.

  

Beginning with version 2.2.0, we have migrated this automation to Windows (.Net 5.0 or higher) project.

If you need the Windows-Legacy project version, please download version 2.1.0.

The Summarize all comments and notes in Excel automation allows you to quickly summarize your Excel comments and notes in a single place. It turns on macros for your machine, uses VBA code to summarize your workbook’s comments and notes in new tabs, and turns off macros for your machine. This automation is great for reviewing notes in your workbook, creating snapshots of your workbook comments, or responding to comments from others.

  

This automation requires “Trust access to the VBA project object model” to be enabled in Excel. The automation will attempt to enable this setting for you, but you may need to turn it on manually if it fails. Please refer to the user guide for instructions on how to enable this setting.

This automation summarizes the comments and notes in Excel workbook(s).

The Summarize all comments and notes in Excel automation allows you to quickly summarize your Excel comments and notes in a single place. It turns on macros for your machine, uses VBA code to summarize your workbook’s comments and notes in new tabs, and turns off macros for your machine. This automation is great for reviewing notes in your workbook, creating snapshots of your workbook comments, or responding to comments from others.

  

This automation requires “Trust access to the VBA project object model” to be enabled in Excel. The automation will attempt to enable this setting for you, but you may need to turn it on manually if it fails. Please refer to the user guide for instructions on how to enable this setting.

  

Beginning with version 2.2.0, we have migrated this automation to Windows (.Net 5.0 or higher) project.

If you need the Windows-Legacy project version, please download version 2.1.0.