Read only second sheet from multiple files

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

1 Like

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

1 Like

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

1 Like

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

2 Likes