Hi everyone, I am working on a process which has a master excel. This excel contains around 40+ rows and 11+ columns. The first row header is unique for all the row. In the process we are passing the data table to each workflow to get the result. What I am thinking is to convert the whole data tab…

@Tuannna1 Please follow below steps First initialize the dictionary - New Dictionary(Of String,List(Of String)) Use a loop to loop through each column Dt.Columns and change the type argument to System.Data.DataColumn Inside use use assign dict(item.ColumnName) = st.AsEnumerable.Select(function…

Creating a Dictionary of list from excel file

Help Studio

system (system) Closed January 16, 2023, 4:01pm 4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.

Topic		Replies	Views
Creating a Dictionary of list from excel Help	10	10360	August 30, 2019
Converting data table to dictionary Studio excel	6	2438	January 3, 2024
Excel -Data table to dictionary Activities datatable , excel , studio , question , dictionary	3	528	September 15, 2023
Convert datatable to dictionary with repeating values Studio datatable	7	2521	February 7, 2021
How to covert the three datarows into one data Dictionary Learning Hub datatable , excel , uiautomation , question	9	2365	July 15, 2020

Creating a Dictionary of list from excel file

Related topics