Have Excel Headers with more than 1 line

Help Studio
, ,
1

I have an excel and some headers are more than 1 line(i.e in next line).
For example the Header/Column name is like Common
Name
How to read those columns using Data table as these are not in 1 line.

2

Hi,

In this case, we need to join these names (header and item of the first row) and remove it (the first row). The following sample will help you.

img20220204-1
img20220204-11109×641 34.1 KB

Regards,

3

Hi, May be I didn’t explained it properly in the question…headers contains new line in the same cell. Attached the example
ColumnIssue

4

Hi,

Can you try as the following? Either one will work.

row("Column"+vbCrLF+"Name")

OR

row("Column"+vbLf+"Name")

If linebreak exists at the end of the column name, please add vbCrlf or vbLf as same.

Regards,

5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.