Creating a Dictionary of list from excel file

Help Studio
, , ,
3

Hi @Tuannna1 ,

An Alternate using Linq approach :

  1. Create a Dictionary variable and initialise it using Assign Activity, say dictOfColumnValues.
dictOfColumnValues = new Dictionary(Of String,List(Of String))
  1. Next, you could use the below Expression using Assign Activity to get the Dictionary values created :
dictOfColumnValues = DT.Columns.Cast(Of System.Data.DataColumn).ToDictionary(Function(x)x.ColumnName,Function(y)DT.AsEnumerable.Select(Function(s)s(y.ColumnName).ToString).ToList)

Let us know if you are not able to get the required output.

3 Likes