Excel - Loop over Sheets and turn into individual Files - KNIME Forum (78171)

0 ×

URL: Import EXCEL - a meta workflow trying to answer questions about importing data from Excel files https://hub.knime.com/-/spaces/-/~BxiMlBJ2jYCPlZnS/current-state/
URL: forum entry (78171) https://forum.knime.com/t/create-individual-excel-files-from-multiple-worksheets/78171/2?u=mlauber71
URL: KNIME Snippets — A Collection https://medium.com/@mlxl/knime-snippets-a-collection-73b024344790
URL: Create path variables https://forum.knime.com/t/write-multiple-csv-file-to-a-loop/44989/2?u=mlauber71
URL: extract paths stored https://forum.knime.com/t/add-read-sheet-protection-to-excel-file/63860/5?u=mlauber71
URL: A meta collection about Loops, Switches, Paths and Flow Variables in KNIME (and some ZIP files) https://hub.knime.com/-/spaces/-/~CET0X2z2VY9oKlYN/current-state/
URL: KNIME forum question (49352) - loop thru file steered by a meta file and extract certain rows https://hub.knime.com/-/spaces/-/~z840Qefa8dG4EVQ0/current-state/
URL: Excel – loop overwrite in the first loop https://forum.knime.com/t/group-loop-not-working-with-sheets-renaming/61194/2?u=mlauber71

Nodes

• Create File/Folder Variables2 ×
• Create Folder1 ×
• Excel Reader1 ×
• Excel Writer1 ×
• Read Excel Sheet Names1 ×
• Table Row to Variable Loop Start1 ×
• Variable Loop End1 ×

Extensions

• FeatureKNIME Base nodes
• FeatureKNIME Excel Support

Links

• No links available