80caeae1-269c-4ffe-91ea-b206b47d2bba.png

b08830ca-c044-46f7-a91a-a33e3187279c.JPG

3a516fd1-ec00-4188-a0a5-83714f996985.nupkg

In REFramework model it is easy to initialize the configuration through **InitAllSettings** workflow, but in a normal flowchart process, it is a very time-consuming task to read configure variable from an Excel file and then save it in a Dictionary object.

This listing solves this problem in an easy way.

  

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 .

  

**NOTE:** If you are familiar with REFramework, this component does the same thing as **InitAllSettings** workflow does.

This package outputs a Settings Dictionary with key/value pairs.

9fcfc122-3011-4f29-8995-4eec43019889.png

2c5e7c25-ec1f-4252-9e02-0e107bbe68c0.png

6a005637-e911-47ee-a2e1-fcae4ab10d1e.png

4a35b393-b52a-43d3-983f-115d671dd89b.png

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.

Visual Basic

77698a91-e57a-405d-aca3-f34ecd1035d1.pdf

663062d8-1bfa-4a68-b1a9-158d70586890.zip

206133b9-e06a-4db4-ac00-5e9f5c599601.nupkg

In REFramework model it is easy to initialize the configuration through **InitAllSettings** workflow, but in a normal flowchart process it is a very time-consuming task to read configure variable from an Excel file and then save it in a Dictionary object.

This listing solves this problem in an easy way.

  

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 .

  

**NOTE:** If you are familiar with REFramework, this activity does the same thing as **InitAllSettings** workflow does.

バージョン	リリース日	ダウンロードリンク
2.0.1	2023年11月28日
This version is Cross-Platform compatible.
1.2.3	2020年12月4日
Added video

Auxiliobits - Convert Excel to Dictionary