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.
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
- .Net runtime 4.6 or later
Inputs: Excel file name and action details