Install
Download the Bot and follow the instructions to install it in your AAE Control Room.
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.