I do not need to append but to separate. I have an Excel file with 10 Sheets (Tabs) and would like to have these ten Sheets each as one individual Excel file with one Sheet , the original name of the sheet shout be the name of the new excel file .
Hi @StephanieWEISS ,
Welcome to the KNIME forum.
I will suggest use: Read Excel Sheet Names – KNIME Community Hub and then Chunk Loop Start – KNIME Community Hub and read each Excel Sheet and Write in Excel (please also close the loop).
Use variables to in Excel Reader to select the Sheet name dynamically.
If you want to name your file with sheet name you can do that as well.
Please do let us know if the solution works for you or if you have any questions.
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.