From the course: Complete Guide to UiPath RPA Development

Unlock this course with a free trial

Join today to access over 24,700 courses taught by industry experts.

Solution: Read Excel config file

Solution: Read Excel config file - UiPath Tutorial

From the course: Complete Guide to UiPath RPA Development

Start my 1-month free trial Buy for my team

Solution: Read Excel config file

“

- [Instructor] Okay, let's get started on the solution. I'll double click and rename my main sequence to read Excel config file. And now within this scope, I'll click on variables and click here to create a variable called config. And as we learned in the dictionary's lecture, in the variables section, I'll set my variable type by clicking on browse for types, and I'll type in dictionary with a less than symbol, and I'll make sure dictionary TKey TValue is selected. I'll choose string for the type of my key and object for the type of my value. click on okay to save that. And now I can close up my variables, CTRL+S to save. And now the gist of how this is going to work is we're going to read the range in here which is going to give us a data table with two columns, name and value. And of course it's going to have five rows. And we're going to need to loop through those five rows of the data table that we get by reading the range and then add a new dictionary item for each of these name…

Contents