Icon

kn_​forum_​71840_​concatenate_​excel_​files

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

Outer Loop - one loop per sheet name Inner Loop - collect the data from the sheets with the same name collect the names of all Excel Sheets from all Excel files from a source folder and import them back to KNIMEhttps://forum.knime.com/t/concatenate-files-from-sharepoint/71840/19?u=mlauber71 import multiple Excel files - forum question 27716https://forum.knime.com/t/online-course-l2-dw-knime-analytics-platform-for-data-wranglers-advanced/27716/15?u=mlauber71https://hub.knime.com/-/spaces/-/latest/~I81HgKcbWamoc5yB/Consolidate Multiple Excel Files into Onehttps://hub.knime.com/-/spaces/-/latest/~FmdPzlURhj1Z-ohE/ raed sheet namesfromnew_excel_multiple_sheets.xlsxlist all.xlsxFiles in /data//source/ foldercollect allsheet namesloop thru all sheet namesOUTER startreadsheets with the samename from all Excel Filescollect the datafrom all the sheets with the same namecreate a Pathvariabel for the ttarget Excel file(one per sheet)v_name_part=> define a namefor the target Excel filewrite target Excel fileloop thru all sheet namesOUTER end Read ExcelSheet Names List Files/Folders Table Row ToVariable Loop Start Loop End Group Loop Start Excel Reader Table Row ToVariable Loop Start Loop End Create File/FolderVariables Java EditVariable (simple) Excel Writer Variable Loop End Outer Loop - one loop per sheet name Inner Loop - collect the data from the sheets with the same name collect the names of all Excel Sheets from all Excel files from a source folder and import them back to KNIMEhttps://forum.knime.com/t/concatenate-files-from-sharepoint/71840/19?u=mlauber71 import multiple Excel files - forum question 27716https://forum.knime.com/t/online-course-l2-dw-knime-analytics-platform-for-data-wranglers-advanced/27716/15?u=mlauber71https://hub.knime.com/-/spaces/-/latest/~I81HgKcbWamoc5yB/Consolidate Multiple Excel Files into Onehttps://hub.knime.com/-/spaces/-/latest/~FmdPzlURhj1Z-ohE/ raed sheet namesfromnew_excel_multiple_sheets.xlsxlist all.xlsxFiles in /data//source/ foldercollect allsheet namesloop thru all sheet namesOUTER startreadsheets with the samename from all Excel Filescollect the datafrom all the sheets with the same namecreate a Pathvariabel for the ttarget Excel file(one per sheet)v_name_part=> define a namefor the target Excel filewrite target Excel fileloop thru all sheet namesOUTER endRead ExcelSheet Names List Files/Folders Table Row ToVariable Loop Start Loop End Group Loop Start Excel Reader Table Row ToVariable Loop Start Loop End Create File/FolderVariables Java EditVariable (simple) Excel Writer Variable Loop End

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: m_lauber
Created at: 2023-08-23
On NodePit since: 2023-08-24
Last update: 2024-04-27
Created with KNIME version: v4.7.7
Tags: excellooppathvariablesheetname

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

Try NodePit Runner!