Cant read double line column header

I have an excel table with double line column headers e.g

I tried reading them with row(“Materialnr./narticle no.”) and also row(“Materialnr.” +/n+ “article no.”), but it’s not working. Any ideas ? Renaming the columns is not an option. Thanks in advance.

maybe you can work with column index instead

other options are:

  • rename Column - dtVar.Columns(ColNameOrIndex).Columnname = NewName
  • give a try on row(“Materialnr.” +CodeSeeSreenshot below+ “article no.”)


1 Like

How about “row(9)” for column “J” ?

1 Like

Hi @RoboBob,

I think the column in excel has wrap text property enabled.
Can you un select the property and then try reading the data to a datatable.


1 Like

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