Icon

KNIME_​Copy Multi Excel to One

Read in Excel spreadsheets from a folder. Each input xlsxfile contains a single sheet of unknown name,.So iterate the files. Iterate the (one) sheet in each file, andwrite each to a sheet in a destination xlsx using thefilename from the source as the sheet name.May 8th 2021, @takbb Brian Bates Get list of filesIterate file namesGets sheet namefor current fileThis workflow assumes there is only one sheet per fileIterate sheets forcurrent fileCreates required Path Variable for Excel ReaderRead the sheetPath as a Stringto be used to create sheet name?End loop forInput Folder FilesOutput filename is static as only single destinationSheet name is set by variableSet to Append file if it exists,but to replace sheetThis then creates one filewith 3 sheetsEnd sheetname loop(we are assuming onlya single sheet, but we don't know its name, so we)I used java to get a sheet_namebased on original file_namebut you can use whatever you like to createa variable with the required outputsheet name List Files/Folders Table Row ToVariable Loop Start Read ExcelSheet Names Table Row ToVariable Loop Start Excel Reader Path to String(Variable) Loop End Excel Writer Variable Loop End Java Edit Variable Read in Excel spreadsheets from a folder. Each input xlsxfile contains a single sheet of unknown name,.So iterate the files. Iterate the (one) sheet in each file, andwrite each to a sheet in a destination xlsx using thefilename from the source as the sheet name.May 8th 2021, @takbb Brian Bates Get list of filesIterate file namesGets sheet namefor current fileThis workflow assumes there is only one sheet per fileIterate sheets forcurrent fileCreates required Path Variable for Excel ReaderRead the sheetPath as a Stringto be used to create sheet name?End loop forInput Folder FilesOutput filename is static as only single destinationSheet name is set by variableSet to Append file if it exists,but to replace sheetThis then creates one filewith 3 sheetsEnd sheetname loop(we are assuming onlya single sheet, but we don't know its name, so we)I used java to get a sheet_namebased on original file_namebut you can use whatever you like to createa variable with the required outputsheet nameList Files/Folders Table Row ToVariable Loop Start Read ExcelSheet Names Table Row ToVariable Loop Start Excel Reader Path to String(Variable) Loop End Excel Writer Variable Loop End Java Edit Variable

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: @takbb Brian Bates
Created at: 2021-05-08
On NodePit since: 2022-02-06
Last update: 2024-11-21
Created with KNIME version: v4.3.2

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!