Fetch Record from Excel and add to array of List

Help Forum
1

Ex - I have One Column “Name” in Excel ! I want to add a Name in the array of List !

2

Hi @Rohan_Dhole

Try this expression

DtMaster.AsEnumerable().Select(Function(w) Convert.Tostring(w("Name"))).Tolist

Regards
Gokul

3

Hi @Rohan_Dhole

Could you give this a try?

Dt.AsEnumerable().Select(Function(s) s("Name").ToString.Trim).ToList()

But if you were serious about an Array of List, then here you go->

Dt.AsEnumerable().Select(Function(s) New List(Of String) From {s("Name").ToString.Trim}).ToArray()

Kind Regards,
Ashwin A.K

Kind Regards,
Ashwin A.K

4

Okay! I will apply this Expression! Let you Know!

5

Thank you! I will try to implement this expression!

6

Hi @Rohan_Dhole

Let us know, If you face any challenges

Regards
Gokul