Nowadays, MS Excel is being used by more than 80% of businesses and millions of users across the globe. Its most common use cases include but are not limited to business analysis, people management, office administration, strategic analysis, and others.
BalaReva - Excel Automation for Enterprises is designed to automate the wide spectrum of your Excel tasks whether at work or for personal use. It offers more than 100 activities that cover the most common Excel processes to speed up your projects.
The package is a new generation of well-known BalaReva Excel Activities. It has been enhanced by adding new activities such as:
Moreover, BalaReva - Excel Automation for Enterprises has been refactored and is now based on the UiPath Activity Creator Plugin which helps prevent potential compatibility issues with UiPath Studio. Also, it’s supported by the vendor and successfully passed all Marketplace security checks, thus getting a Gold Certified badge.
Some of the most important activities are listed below:
TimeLineFilterNavigator - set the start and end range of the TimeLine.
SlicerFilterSelectItem - select multiple items in the Slicer. It has a feature to deselect all the items.
DropDownSelect - select the dropdown item in Excel.
AddNote - add a new note to the cell.
ChartEmbedToPowerPoint - export or embed the Excel chart to PowerPoint.
RemoveFilter - remove the filters.
Add Header Image - add Header with image and text with alignment (left, right, or center).
Add Footer Image - adding Footer with image and text with alignment (left, right, or center).
TabColor - сhange the tab color of the Excel workbook.
CombineSheetByRow - combine 2 Excel sheets row-wise.
ExportToTextFile - export the Excel sheet as a text file.