Auxiliobits is a global Robotic Process Automation and Artificial Intelligence advisory company. We are a global consulting firm who helps integrate Robotic Process Automation in an enterprise business model. We also partner with enterprises for their need to train their in-house workforce to be ready for the future of robotic process automation’s digital workforce. As a company we are implementation and training partners with experienced and acclaimed RPA platforms of the world.Auxiliobits vision is to enable any domain of an enterprise business to leverage the digitization of the workforce and realize quick benefits with a minimal disruption to the underlying systems. We are committed to improve customer experiences for enterprises by helping them integrate and implement RPA strategies that will help digitize and automate their processes and workflows.

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.

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

This package outputs a settings Dictionary with key/value pairs

MIT License Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the 'Software'), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions: The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED 'AS IS', WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.

Robot Master

Visual Basic

It seems the provided documentation has experienced from AWS. Can you please upload

Hello Sandeep ,is this  components work where Excel is not installed.

i want to convert csv to dictionary so do it work???

When using this activity, I am getting an error 'Excel to dictionary: An item with the same key has already been added."??

Great Utility - Does the job exactly right. I wondered how InitAllSettings workflow would gracefully read the config file as a dictionary of key/value pairs. All that is done using this single activity.


Simple and to the point - Good job on publishing your first component! I've used it and it works! One thing I think you could have in mind for the following version would be if you could add an option to read without headers (without Name/Value one the first row).


 - This is an great alternative to making your dictionaries. 


Excellent...This is probably the best way to load configuration...

Auxiliobits - Convert Excel to Dictionary

Auxiliobits - Convert Excel to Dictionary

Help

How To