# Parallel-process multiple Excel files by sheet name in a single KNIME workflow

**URL:** <https://forum.knime.com/t/parallel-process-multiple-excel-files-by-sheet-name-in-a-single-knime-workflow/84126>\
**Category:** KNIME Analytics Platform\
**Created:** [October 28, 2024, 5:38am UTC](https://forum.knime.com/t/parallel-process-multiple-excel-files-by-sheet-name-in-a-single-knime-workflow/84126 "2024-10-28T05:38:31Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![mlauber71](https://forum-cdn.knime.com/user_avatar/forum.knime.com/mlauber71/32/73590_2.png) [@mlauber71](https://forum.knime.com/u/mlauber71)\
**Post date:** [October 28, 2024, 7:04am UTC](https://forum.knime.com/t/parallel-process-multiple-excel-files-by-sheet-name-in-a-single-knime-workflow/84126/2 "2024-10-28T07:04:46Z")

</div>

@san_98 from what I recall we had a similar thread about parallel processes

> [@Parallel Processing of Multiple Excel Files Based on Dynamic Sheet Names from List Files/Folders Node in KNIME](https://forum.knime.com/t/parallel-processing-of-multiple-excel-files-based-on-dynamic-sheet-names-from-list-files-folders-node-in-knime/84034/7):
>
> @san_98 In your screenshot I do not see any Parallel Chunks and no database access, but if you are fine we are fine slight_smile For the fun of it I expanded on @MartinDDDD workflow and constructed a parallel access with a database node calling sub-workflow(s) that would then use this connection. So far it seems to work although any benefits in speed might depend heavily on the actual database(-connetion) supporting parallel access. The callee workflow does look like this:

Maybe you can combine it with these information

> [@Create individual excel files from multiple worksheets](https://forum.knime.com/t/create-individual-excel-files-from-multiple-worksheets/78171/2):
>
> @lazaronewhall17 yes this can be done. With such tasks you can combine several nodes into a system to handle your files. You read the Excel Sheet names and feed them into a Table Row to Variable Loop start to iterate over them (you can expand this obviously to several files). You [create Path variables](https://forum.knime.com/t/write-multiple-csv-file-to-a-loop/44989/2) for a new sub-folder: Using the name of the “Sheet” as Folder name from the Flow Variable (you can use other things too, or you can just skip this part): [image] You then c…

---

_[View the full topic](https://forum.knime.com/t/parallel-process-multiple-excel-files-by-sheet-name-in-a-single-knime-workflow/84126)._
