This bot is used to perform multiple Excel Operations in a user-specified Excel file
Top Benefits
Performs ten different types of Excel operations
Provides error free data output
Tasks
This bot performs the following Excel operations, Excel to PDF, Get number of worksheets
Find content, Get Single cell
Get worksheet name, Get number of rows
Get Column Data, Get Row Data
Get Cell color, Read cell Formula
This bot performs various Excel operations including:
- Excel to PDF conversion
- Get number of worksheets
- Find content
- Get Single cell
- Get worksheet name
- Get number of rows
- Get Column Data
- Get Row Data
- Get Cell color
- Read cell Formula
The user can choose the required excel operation from an interactive form. For Excel to PDF conversion, the output file will be created and stored in the output folder. The other actions output will be displayed in a message box.
See the Bot in Action
Setup process
Install
Download the Bot and follow the instructions to install it in your AAE Control Room.
Configure
Use the Bot in a bot, configure keys and other credentials the Bot will need (see the ReadMe for details.)