Excel reader - multiple sheets

Hi Guys,

quick one - i have an excel file with multiple sheets within.

Each sheet contains some data to be used as different inputs in my workflow. Is there a way I can put just one excel reader and have as output al the sheets in different output ports? Instead of creating multiple excel readers, one per each sheet?

Thanks!

Mario

Hi @MarioKnimer,

no that’s not possible. If you want to concatenate the rows or append the columns of all sheets into one table, you can loop over the sheets, see this example workflow: https://kni.me/w/a2XQGQ7J9u0N6IZt.

Best,
Simon

3 Likes

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