Convert string in excel field into a dictionary

[Aishwarya_Maggi]

Excel field contains multiple skills and level the person has a skill separated by a new line.

e.g. Skills: ’ French L2, German L1, Spanish L5’

I need to access the skill name and the level of each skill. Is there a way to convert the string in the skills field into a dictionary?

e.g. mydict = {French: L2, German: L1, Spanish: L5}

How do I later access the element of the dictionary in UiPAth?

[Susana (Susana González Cacheiro)]

Hi @Aishwarya_Maggi,

Hope this could help you:

You need to install Microsoft.Activities.Extension for using the dictionary activities:

Adding items to a dictionary

Hello Every body, I am trying to use a data dictionary to storage my variables. However, when I use the activity “Add to dictionary” Uipath shows an error message which mentions the following “The dictionary has not been initialized”. My dictionary variable has a type System.Collections.Generic.Dictionary<TKey, TValue> Can someone tell help me? What is missing? How can I must declare my variable to establish it as a data dictionary?

Best Regards,
Susana