Read excel as a text

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.

@murat.karasoy

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.