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
Thanks
I want to only get all excel as a string.
Hi,
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))
Regards,
1 Like
It worked. Thank you
1 Like
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.