Attached is the KNIME workflow to load mutiple Excel files with mutiple sheets into an excel file. These excel sheets contains fields as columns so needs some manupulation. However, I have noted when I run this workflow, it duplicates the first sheet of each workbook.
The solution is to select file and sheet tab on excel reader, then select the radial button “By Name”.