Cant read double line column header

Help
,
1

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

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.

2

@RoboBob
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.”)

grafik

1 Like
3

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

1 Like
4

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.

Thanks

1 Like
5

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