Reading all sheets of all files in a folder and create a formatted output with multiple sheets

Hi everyone,

I’m working on a complex KNIME workflow that I currently have split into two parts — but I’d really like to combine them into one.

What I’m doing:

1. Data Preparation

I read all sheets from all Excel files in a folder. Based on the sheet names, I categorize and write the output into a new Excel file with multiple sheets.

1. Formatting

In a separate workflow, I format all sheets of that output file using the Continental XLS Formatter nodes.

The challenge:

I’m struggling to properly combine both workflows, especially when it comes to closing the loop.

Has anyone successfully combined data preparation and formatting of multiple sheets in one workflow? Any tips or example workflows would be greatly appreciated!

Thanks so much!