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

Free

Bot Security Program
Level 1
Applications
Business Process
Category
Downloads
1365
Vendor
Automation Type
Bot
Last Updated
February 7, 2020
First Published
May 29, 2019
Enterprise Version
11.3
Community Version
-1
Support

See the Bot in Action

PREV NEXT

Setup Process

Install

Download the Bot and follow the instructions to install it in your AAE Control Room.

Configure

Open the Bot to configure your username and other settings the Bot will need (see the Installation Guide or ReadMe for details.)

Run

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