As there is a new XLS Reader Node available with 4.3 I was starting to exchange the old nodes with the new one.
But I’m facing some challenges as some internals and behaviour of the node did change:
- The new node does not allow me to define the filename with a variable. When hitting the variable button I can’ select any of my existing variables. All I can do is to create a new variable.
What’s wrong with my approach?
- The old xls reader node did use a column naming scheme with “Col1, Col2, Col3, …”. That was different to the EXCEL one. So I assume that due to this difference the new column naming scheme is now as in EXCEL “A, B, C, …”. But now I’m facing the challenge that I need to rework all my work flows based on the xls Reader Node to adjust the new column names. That’s more than nasty.
Is there either a change to adapt the column naming scheme back to “Col1, Col2, …”?
Or do some tools exist which help me to find and adapt all occurences of the column names?