Hi guy, I want to get all excel as a string like read pdf text. I use read range and Output Data Table. But I get all lot of comma(,) and lost my real comma.
Can you share a input sample and output sample files
That will help to understand your issue
I want to only get all excel as a string.
Can you try the following expression? (Let’s say dt is datatable type variable which is read using ReadRange)
String.Join(vbCrLf,(dt.AsEnumerable.Select(Function(r) String.Join(chr(9),dt.Columns.Cast(Of DataColumn).Select(Function(c) r(c).ToString()).toArray)).ToArray))
It worked. Thank you
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.