How do I read an array from an Excel config file

excel
file
activities
studio
configuration

#1

I’m going to use an Excel table as a config file. I’m willing to put an array of string as a value. How do I correctly read it from UiPath so that it could understand that it’s an array actually?

For instance, this is how the excel table might look:
Name Value
myString {“a”,“bc”,“de”,fghij",“k”}

When I previously used an Excel config I created a dictionary variable, say, “config”, in UiPath, of string and object. And then I created, say, an Integer variable and assigned Convert.ToInt32(config(“myValue”).ToString)

But how can I do it in the case I read what is supposed to be an array?

The only way I seem to have is to read it to a string variable and then split it by a comma. But I may miss something.


#2

@MGMKLML Read it as string variable and split it by comma. I Think this will work correctly


#3

@Manjuts90 Thank you :slight_smile: Yeah this is a way out but I thought there could be more elegant solutions, you know :smiley: