How to convert an excel column to comma separated date

In an excel i have values given in a column i need to change it to comma separated data.
Example
In column A i have the values
24
25
27
28

i need these values in a string as “24”,“25”,“27”,“28”

@karan_kapoor1

You can declare a variable as Array and write as below

datatablename.AsEnumerable().Select(Function (a) a.Field(of string)(“columnname”).ToString).ToArray()

Hope this helps you

Thanks

1 Like

This would work, good one @ksrinu070184 :slight_smile:

1 Like