Create your first automation in just a few minutes.Try Studio Web →
by UiPath
0
Activity
179
Summary
Summary
The Excel Activities package aids users to automate all aspects of Microsoft Excel.
Overview
Overview
The Excel Activities package is designed to streamline and automate various facets of Microsoft Excel—a ubiquitous application integral to operations across diverse business sectors.
Encompassing a versatile range of activities, this package empowers users to automate tasks within Excel, providing ways for extracting information from cells, columns, rows, or specific ranges. Beyond mere data extraction, users can efficiently write to alternative spreadsheets or workbooks, execute macros, and extract formulas. Moreover, the package facilitates dynamic data manipulation, allowing users to sort information, apply color codes, or seamlessly append supplementary data, thereby enhancing the overall efficiency of Excel-related workflows.
The activities within this package are categorized into three distinct groups:
Under the Modern category, users can access the latest activities tailored initially for the StudioX profile. These activities empower users to execute a diverse array of Excel-related operations. It encompasses functionalities such as deleting and inserting columns, rows, and sheets, reading cell values, formulas, and ranges, updating Excel charts, saving documents as PDFs, and performing VLookup operations.
Workbook activities function even in the absence of Microsoft Excel installed on the machine. Users can exclusively read and write data to and from files, enabling efficient data extraction from cells, columns, rows, and entire workbooks. This category is particularly advantageous for scenarios where direct interaction with Excel on the machine may not be feasible, providing a reliable method for data transfer.
The Classic Activities category automates a wide spectrum of Excel-related operations, catering to a broad array of user requirements. From reading or writing CSV files to creating, filtering, and sorting tables, and generating pivot tables, these activities serve as the backbone for traditional Excel automation needs. This category ensures compatibility with established workflows, offering a robust set of tools for users familiar with more traditional Excel automation methodologies.
Features
Features
The Excel Activities package can cater to diverse automation needs within Microsoft Excel such as:
Additional Information
Additional Information
Dependencies
ClosedXML, CsvHelper, DocumentFormat.OpenXml, Microsoft.VisualStudio.OLE.Interop, NPOI, SharpZipLib, System.Text.Encoding.CodePages, UiPath.Platform, UiPath.Telemetry.Client, ClosedXML, CsvHelper, DocumentFormat.OpenXml, NPOI, SharpZipLib, System.Text.Encoding.CodePages, UiPath.Platform, UiPath.Telemetry.Client, ClosedXML, CsvHelper, DocumentFormat.OpenXml, Microsoft.VisualStudio.OLE.Interop, NPOI, SharpZipLib, System.Text.Encoding.CodePages, UiPath.Platform, UiPath.Telemetry.Client
Technical
Version
2.24.3Updated
October 27, 2024Certification
Gold Certified
Support
Link: https://www.uipath.com/company/contact-us/contact-technical-supportUiPath Standard Support, see your Service Agreement