Datatable multiline header columname


#1

Hi,
I read a full Excel with Read Range (+add headers).
I can perfectly read the singleline headers, but not the multiline headers.

When I print the columnames the multilineheaders are printed like this: “first line \n second line”. But this does not work if I put it as Datatable(“first line \n second line”).tostring, or even if I try Datatable("First line " + environment.newline + “second line”).tostring

Changing to singleline headers is not an option (not my Excel)

Any ideas?


#2

For future reference:

use datatable(“first line” + vblf + “next line”).tostring