LINQ Query to Convert Data Column Values to List

[Random_Bot]

I need a linq query to convert particular excel column data to List

Input:

Name	Marks
John	123
Bob	435
Rony	34
Jimmy	54

Expecte output: {“John”,“Bob”,“Rony”,“Jimmy”}

[Vinit_Mhatre (BotBuilder)]

Hi @Random_Bot ,

You can do this as below

Assign ----> Name as List [System.Collections.Generic.List] :

(From row In dt_input.AsEnumerable() Select Convert.Tostring(row("Name")) ).ToList()

Regards,
Vinit Mhatre

[Parvathy (PS Parvathy)]

Hi @Random_Bot

Try this linq:

namesList = (From row In dt.AsEnumerable() Select row.Field(Of String)("Name")).ToList()

namesList is of DataType System.Collections.Generic.List(Of String)

Regards

[Random_Bot]

Thanks @Vinit_Mhatre and @Parvathy