collect the names of all Excel Sheets from all Excel files from a source folder and import them back to KNIME

collect the names of all Excel Sheets from all Excel files from a source folder and import them back to KNIME

External resources

• forum entry
• import multiple Excel files - forum question 27716
• HUB: Consolidate Multiple Excel Files into One
• Excel Reader - force sheet_selection "NAME" with Flow variable
• Read the sheet names from an existing excel file and add the sheet name as a column and write to a new excel file
• Excel Sheet names and index of Sheets - KNIME forum (66488)
• use Python Pandas and Openpyxl to import and export Excel (sheets) and Export them back - also append to an existing Excel file
• This workflow demonstrates how to use the new Excel Reader and path variables and read Excel sheets
• This workflow demonstrates how to use the new Excel Reader and path variables and read Excel sheets and skip a step when a file is missing