How to get columns from xls

Good day. I want to pull two columns from an xls file. I tried using a range like A:B; however, the system gives no output. I had to resort to hardcoding as shown in the picture. How can I correctly write the expression so that the system takes entire columns? Thank you.

It looks like your topic is missing some important information. Could you provide the following if applicable.

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:

it’s really doesnt matter.
The only thing: i’m using the last version of n8n

Hey @Aliaksei,

Welcome to the community :cake:

Looks like you have found a bug in the node there, I have created NODE-1110 as the internal ticket and linked this topic to it so we can let you know once it has been fixed.

For now the workaround you have found looks to be the best approach.

@Jon I see. Thanks

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