Multiple Excel Operations

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.

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.)

Run

That's it - now the Bot is ready to get going!

Requirements and Inputs

  • Automation 360 setup to run in your machine
  • Bot creator license
  • MS Office / WPS Office Input - Any Excel File

Customer Reviews

0.0(0 reviews)

No reviews yet.