I need to split an Excel file into multiple sheets.
I need to use sheets within a single Excel file to feed multiple nodes without having to use the same “Excel Reader” node multiple times. Is this possible? Thank you in advance.
Its not entirely clear what you want to do. See if this helps.
@Jean_Loaiza you can take a look at this article to give you ideas how to handle things.
Also you might give us a small example of what you want to do
Does your Excel file have multiple worksheets and you want to open them in batch? Do they have the same schema (structure)?
Yes, exactly. I need to extract from the same excel file different sheets to feed multiples noodles (each sheet will feed a specific noodle) without having to set up an “excel reader” noodle for each noodle.
You would use the Read Excel Sheet Names node to get a list of sheet names, and then you could pass them to the Excel reader as a variable to loop through each sheet. Ask chatgpt or check out the links in the previous post for examples KNIME, Paths and Loops — Automate Everything | by Markus Lauber | Low Code for Data Science | Medium
2 Likes