Connect HomeMarketplaceComponentsAuxiliobits - Convert Excel to Dictionary

Auxiliobits - Convert Excel to Dictionary

Custom Activity

Custom Activity

Updated: October 14th, 2020

Published: May 10th, 2019

Downloads: 140

Language compatibility: Visual Basic

Community Support

Auxiliobits - Convert Excel to Dictionary

Custom Activity

Summary: 

This component outputs a settings Dictionary with key/value pairs

Settings are read from a local Excel file (.xls or .xlsx) that stands for Input.
This activity takes one Input that is the Path of the excel file (.xls or .xlsx) as String.
Output is the collection variable as Dictionary <String,object>.
In Reframework model it is easy to initialize the configuration through InitAllSettings workflow, but in normal flowchart process it is a very time consuming task to read configure variable from an Excel file then save it in a Dictionary object.
This component solves this problem in an easy way.
NOTE: If you are familiar with Reframework, this component does the same thing like InitAllSettings workflow does.

Details

Benefits

This component solves in an easy way the problem of the very time consuming task to read configure variable from an Excel file then save it in Dictionary object.

Compatibility

UiPath 2018.3+

Dependencies

Microsoft Excel (.xls or .xlsx)

Resources

- Convert_Excel_to_Dictionary.pdf

Licensing

By clicking download you agree to the following license.