Excel Utilities

Tasks

• 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!