Perform Various Excel Operations

This bot helps with any business process where you need Excel manipulation. It supports a wide variety of Excel operations for you, including:

• Change the background color of a range using a hexadecimal color code
• Change the background color of a range using a RGB color code
• Return the background color code for a given cell
• Return the background color 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
• Delete 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
• Cut and paste an Excel range
• Sort a data range based on column range
• Password protect a worksheet
• Remove the protection from a worksheet
• Hide a worksheet
• Show a worksheet
• Return the number of columns in a worksheet
• Return number of rows in a sheet
• Copy a worksheet to another
• Rename a worksheet
• Refresh pivot tables in a worksheet
• Refresh all pivot tables in a workbook