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.


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