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.
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.
Copy To File
Set (Change ) Table format