How to convert an excel column to comma separated date

Help
,
1

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”

2

@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()

image
image1871×383 22.2 KB

Hope this helps you

Thanks

1 Like
4

This would work, good one @Srini84 :slight_smile:

1 Like