Separating Excel sheets from an Excel workbook

Knime beginner question: I can see how it’s possible to create Excel files with multiple sheets using the ‘Excel Sheet appender (xls)’ node, but how do you extract all the sheets from a multi-sheet Excel workbook? I have a workbook with multiple sheets that I need to extract and combine into a single table before further manipulation. The Excel reader takes only a single sheet - I can’t see how to get this into a loop to read all the sheets sequentially?

Welcome to KNIME forum. You can get an idea on the topic below.

2 Likes

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