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?

Separating Excel sheets from an Excel workbook

izaychik63 September 6, 2019, 11:57am 2

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

2 Likes