Excel to Dictionary

Excel to Dictionary, is designed to read an XLSX spreadsheet and save it in a Dictionary variable string with only a command

Top Benefits

  • Great for XLSX config/setup files
  • Saves time for RPA developers

Tasks

  • Read a XLSX File
  • Save this XLSX(2 columns) on a Dictionary value

The bot, Excel to Dictionary, is designed to read an XLSX spreadsheet and save it in a Dictionary variable string with only a command. This helps to reduce the RPA Developers' time. Microsoft Excel is not required and only supports XLSX files.
You must input an XLSX file, specify son input commands, like Columns to read, and optionally a Sheet to read and rows to read.

The key use cases include:
• Greet tool for reading config files with XLSX and saving them in a dictionary variable.
• Table of configuration.
• Time Saver.
• Easy to use.

Get Bot

Free

Bot Security Program
Level 1
Applications
Business Process
Category
Downloads
43
Vendor
Automation Type
Bot
Last Updated
October 5, 2021
First Published
October 5, 2021
Platform
Automation 360
ReadMe
ReadMe
Support

See the Bot in Action

Input
Bot Code
Input values
PREV NEXT
Input
Bot Code
Input values

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

  • XLSX Excel File