Perform Various Excel Spreadsheet Operations

Perform various spreadsheet operations using excel. This bot enables you to take charge of your spreadsheets like never before!

Top Benefits

  • Easy to use and integrate in new or existing tasks without any technical supervision.

Tasks

  • Validate spreadsheet data
  • Copy and Paste data from sheet to sheet
  • Create new sheets for performing calculations
This bot is designed to work for any authorized user to perform variety of operation on Excel. Please check "More Details" section for details on parameters.

All the inputs are required and must be correct.

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

Run

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

Requirements and Inputs

  • Microsoft Excel

Customer Reviews

5.0(2 reviews)
5 star50%
4 star0%
3 star0%
2 star0%
1 star0%
Ease of Use0.0
Functionality & Reliability0.0
Documentation & Samples0.0

To filter data please perform the following steps: 1. Use Filter Data Logic from Metabot. 2. Provide appropriate input parameters for the logic. Example : FilterValue : Filter Term, InputFIle : Excel file path, Range : Row:Column range (A1:B5), SheetName : Name of excel sheet, FilterApplyByColName : True, FilterByCol: Column-Row number (B1). Attached Screenshot 3. Save and Run Note : Always good to run ActivateSheet logic beginning of the bot.

aziz.khan

Very helpful for performing various spreadsheet operations without the need of keystrokes and reduces the time. If possible please provide us the example for what input parameters needs to be given for Filter Data Logic

shyam.prakash