- Workbook Level - create workbooks, add/remove worksheets, rename worksheets, color tabs etc.
- Worksheet Level - add/remove columns & rows, create Excel tables, get used ranges, sheet protection, add filters etc.
- Formatting - edit fonts, colors, cell styles, cell alignment
- Pivot - create new or edit existing pivots, add theme, change pivot options
- Image - add or extract images from worksheets
Automation Anywhere provides users with a rich set of features for extracting and manipulating data within an excel workbook; however, there is a gap when it comes to the full formatting features of the Excel Application. The Excel Utilities bot fills this gap by allowing users to create new workbooks, edit workbook properties (new sheets, renaming sheets), worksheet properties (inserting rows, columns columns), format worksheets (cell color, font etc.), image extraction/insertion and pivot table helpers. Excel Utilities bot also does not require the Excel application to be installed on the machine the bot is running. All of these useful features, without the need for Excel!
- Bot Security Program
- Business Process
- Customer Service & SupportFinance & AccountingOperationsSales
- Banking and Financial ServicesProductivityUtility
- Automation Type
- Last Updated
- December 7, 2020
- First Published
- February 10, 2020
- Enterprise Version
See the Bot in Action
Download the Bot and follow the instructions to install it in your AAE Control Room.
Open the Bot to configure your username and other settings the Bot will need (see the Installation Guide or ReadMe for details.)
That's it - now the Bot is ready to get going!
Requirements and Inputs
- Instance of an Excel Workbook - Can be created by the bot or an existing file