Perform Various Excel Operations

Performs various excel actions such as formatting, add/remove rows/columns, add/remove/show/hide columns, etc.

Top Benefits

  • Saves a lot of time for RPA developers.
  • Improves the reliability and reusability of the code.

Change the background colour of a range using a hexadecimal colour code.

Change the background colour of a range using a RGB colour code.

Return the background colour code for a given cell.

Return the background colour code in RGB for a given cell.

Insert a row in between a given range.

Insert a column in between a given range.

Delete rows or columns.

Add a new worksheet.

Delete an existing worksheet.

Activate specific worksheet.

Change the position of a given worksheet by moving it.

Hide the workbook.

Unhide the workbook.

Return the index of a given worksheet.

Return the total number of worksheets.

Return the active worksheet name.

Return the sheet names in XML format.

Check a given worksheet exists.

Cuts and paste an excel range.

Sorts a data range based on column range.

Password protect a worksheet.

Removes the protection from a worksheet.

Hides a worksheet.

Shows a worksheet.

Returns the number of columns in a worksheet.

Returns number of rows in a sheet.

Copy a worksheet to another.

Renames a worksheet.

Refresh pivot tables in a worksheet.

Refresh all pivot tables in a workbook.

Get Bot


Bot Security Program
Level 1
Business Process
Automation Type
Last Updated
February 7, 2020
First Published
May 29, 2019
Enterprise Version

See the Bot in Action


Setup Process


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

  • .Net runtime 4.6 or later MS Office
    Inputs: Excel file name and action details