Copying Data from excel to DT

Help Activities
, ,
1

hi Team,

i have one column in excel and i want to copy the column data to a column that i have created using BUILD DATATABLE activity… i want to do it using LINQ… any help pls

2

Hi @devasaiprasad_K

please find the below linq query.

you can assign columnvalues as datatable.
columnValues = From row In dt.AsEnumerable()
Select row.Field(Of String)(“columnName”).copyToDataTable().

hope it helps!!!