Accelerators
Accelerators
Partner Solutions
Partner Solutions
Professional Services
Professional Services
Collections
Collections
Sign In
Accelerators
Accelerators
Partner Solutions
Partner Solutions
Professional Services
Professional Services
Collections
Collections
Summary
Summary
Overview
Overview
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 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 you can save the file 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).
Features
Features
By using this custom activity you can avoid the effort of multiple interventions in the normal workflow development for Excel processes. It reduces the time and effort required for tedious automation. It is more reliable and very easy to use. It saves execution time.
Additional Information
Additional Information
Dependencies
Code Language
C#, Visual Basic
Runtime
Windows (.Net 5.0 or higher)
Technical
Version
2021.1.0Updated
May 3, 2023Works with
Studio: 21.0 - 22.10+
Certification
Silver Certified
Tags
balareva
excel
uipath
Application
Microsoft Excel
Support
UiPath Community Support
Resources
Similar Listings
