Hello,
i have “List Files” node and i want to read only second sheet from each file. There is the easy way to do that ?
cheers Kacper
Hello,
i have “List Files” node and i want to read only second sheet from each file. There is the easy way to do that ?
cheers Kacper
Hi k0sa,
Sounds like you’re reading Excel files. I think you’ll need to use the ‘Read Excel Sheet Names’ node and then ‘Row Filter’ to filter for the 2nd row. Hope that helps.
Kind regards,
Yush
Hi there,
Additionally you can use R Integration. There are packages where you can specify sheets by its index. Here is link for more info.
Br,
Ivan
Hi k0sa,
To be able to do this for all your files, i would suggest using the ‘table row to variable loop start’ node. This will allow you to loop through all the paths the ‘list files’ node and append the data from the 2nd sheet of each of these files, with the ‘excel reader’ and ‘loop end’ nodes.
Give it a go and if you’re struggling I can make a workflow for you later.
Kind regards,
Yush
This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.
Hi @k0sa,
I just wanted to let you know that the new Excel Reader in version 4.3 supports the option to select sheets by their index. Thanks for the feedback!
Best,
Simon