I’m trying to concatinate a number of values from an Excel spreadsheet, as such:
assign them to a single variable with the following output: 11111100011,222200022/30002022,300030033
But I keep getting the same “Specified cast” error when I use the following function:
String.Join(",",DataTable.AsEnumerable().Select(Function(a) a.Field(Of Double)(“Column X”)).ToArray())
The very same fucntion works if I target a column with consistent numbers which do not have any other elements (like: “/” or “,”).