Scrap Data and Separate


I have a Screen having multiple column. From 1 Column I have to scrap the data and save to Excel.

As per snap shot I want separate the values of Each row (from the screen). and save to single cell e.g(A1). The format should be

Line 1 value - {data} ; Line 2 value - {data} ; Line 3 value - {data}…

The number of lines are not fixed It can any.

Any help or idea would be appreciated.


1 Like

Hey @Gagan_Chaudhari

Yep, that’s possible.

String.Join(" ; ",dtData.AsEnumerable.Select(Function(row, index) "Line " + CStr(index+1) + " value - " + row(0).ToString))

Kindly try this.