Convert and Filter Excel Data

The Bot converts a specific column in an Excel spreadsheet into text and filters the column by the specified values.

Top Benefits

  • Filtering and convert into text

The Bot converts and Excel column into text and filters the column with a specific value.

Get Bot

Free

Bot Security Program
Level 1
Applications
Business Process
Category
Downloads
264
Vendor
Automation Type
Bot
Last Updated
December 22, 2020
First Published
August 20, 2019
Enterprise Version
11.3
Support

See the Bot in Action

PREV NEXT

Setup Process

Install

Download the Bot and follow the instructions to install it in your AAE Control Room.

Configure

Open the Bot to configure your username and other settings the Bot will need (see the Installation Guide or ReadMe for details.)

Run

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

Requirements and Inputs

  • Notepad(for vbscript)
  • Inputs: FilepathSheetnameColumnNameColumnNumberValue to Filter