Describe the problem/error/question
- How to read columns A, B,X and Z alone from the read:sheet node for Google sheets
- and how to limit number of rows read to say 100
Hi @kalai, welcome to the community!
It’s not possible to read for example columns A, B, X, and Z but not the columns between the aforementioned ones. This is a limitation imposed by most spreadsheet applications, which only allow you to specify a connected range (something like columns A to Z). Such a range can also include rows.
So, in order to achieve what you have in mind you’d have to
Hope this helps!
oh, thats cool. since i need most of the initial columns, this would be perfect thank u.
You’re most welcome, glad to hear this helps
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.