# Parallel Processing of Multiple Excel Files Based on Dynamic Sheet Names from List Files/Folders Node in KNIME

**URL:** <https://forum.knime.com/t/parallel-processing-of-multiple-excel-files-based-on-dynamic-sheet-names-from-list-files-folders-node-in-knime/84034>\
**Category:** KNIME Analytics Platform\
**Created:** [October 23, 2024, 9:40am UTC](https://forum.knime.com/t/parallel-processing-of-multiple-excel-files-based-on-dynamic-sheet-names-from-list-files-folders-node-in-knime/84034 "2024-10-23T09:40:44Z")\
**Posts on this page:** 1\
**Showing post:** 6

<div class="post-metadata">

**Author:** ![san\_98](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/s/e47c2d/32.png) [@san\_98](https://forum.knime.com/u/san_98)\
**Post date:** [October 23, 2024, 12:25pm UTC](https://forum.knime.com/t/parallel-processing-of-multiple-excel-files-based-on-dynamic-sheet-names-from-list-files-folders-node-in-knime/84034/6 "2024-10-23T12:25:54Z")

</div>

I used the **List Files/Folders node** to retrieve all the files available in the folder, regardless of the file name. Then, I used the sheet name to read all the available sheets in the Excel files. In my case, I will have more than three sheets in the Excel file. After retrieving the sheets, I applied the **Rule Engine node** to split the workflow based on conditions.

- If the sheet names are the same, the workflow runs in a **loop** to process the sheets.
- If the sheet names are different, the workflow runs in **parallel** to process them concurrently.

This approach ensures that when the sheet names are identical, the process loops through them one by one. If the sheet names vary, the workflow executes in parallel for efficiency…

Please refer the workflow attached.

 ![{BA2E987F-86C8-4AF0-B0CE-4FA26A796B9D}](https://forum-cdn.knime.com/uploads/default/original/3X/0/e/0ec1e44ae28e45ff574befe1281b527931b6d3fa.png)

---

_[View the full topic](https://forum.knime.com/t/parallel-processing-of-multiple-excel-files-based-on-dynamic-sheet-names-from-list-files-folders-node-in-knime/84034)._
