# Appending all worksheets in excel excel file into 1 master worksheet

**URL:** <https://forum.knime.com/t/appending-all-worksheets-in-excel-excel-file-into-1-master-worksheet/81181>\
**Category:** KNIME Analytics Platform\
**Created:** [July 18, 2024, 8:52am UTC](https://forum.knime.com/t/appending-all-worksheets-in-excel-excel-file-into-1-master-worksheet/81181 "2024-07-18T08:52:37Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Dhammapal\_Avhad](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/d/e36b37/32.png) [@Dhammapal\_Avhad](https://forum.knime.com/u/Dhammapal_Avhad)\
**Post date:** [July 18, 2024, 8:52am UTC](https://forum.knime.com/t/appending-all-worksheets-in-excel-excel-file-into-1-master-worksheet/81181/1 "2024-07-18T08:52:37Z")

</div>

I have created a workflow that looks like as shown in the image attached. What i find strange is that it works for 1 excel file but when I use the same workflow for another file then it runs the loop as it is supposed to but always gives the output from first worksheet only and doesnt show any records from 2nd worksheet onwards. Please help me find out what needs to be changed.  
 ![Capture](https://forum-cdn.knime.com/uploads/default/original/3X/2/3/239c1166efbf79585d3403847fab1d82d8ad5341.jpeg)

---

<div class="post-metadata">

**Author:** ![Kazimierz](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/k/cdc98d/32.png) [@Kazimierz](https://forum.knime.com/u/Kazimierz)\
**Post date:** [July 18, 2024, 10:05am UTC](https://forum.knime.com/t/appending-all-worksheets-in-excel-excel-file-into-1-master-worksheet/81181/2 "2024-07-18T10:05:08Z")

</div>

Hi @Dhammapal_Avhad

Welcome to the Community.  
I can only suppose that the ‘issue’ comes from using ‘overwrite’ option instead of ‘append’ in the Excel Reader configuration. I would suggest to play with configuration and see what happens.

The other thing is the KNIME version you use. What works correctly up to version 5.2.5 may work incorrectly in version 5.3. The KNIME internal ticket for this bug is AP-22911.

Happy KNIMEing,  
Kaz

---

<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:** [July 21, 2024, 2:19pm UTC](https://forum.knime.com/t/appending-all-worksheets-in-excel-excel-file-into-1-master-worksheet/81181/3 "2024-07-21T14:19:37Z")

</div>

@Dhammapal_Avhad you can use the KNIME python integration and openpyxl to append data to existing sheets

> [@Data extraction from .xls file/s](https://forum.knime.com/t/data-extraction-from-xls-file-s/29528/12):
>
> @Matt9301 there is a way to do this with the use of [Python](https://hub.knime.com/mlauber71/spaces/Public/latest/_knime_and_python_meta_collection) pandas and [openpyxl](https://openpyxl.readthedocs.io/en/stable/) You would have to provide an existing excel file and a sheet name and then sheets with the same structure.

---

<div class="post-metadata">

**Author:** ![system](https://forum-cdn.knime.com/uploads/default/original/1X/ab3ccf34482a0329361734a18199390177204f15.png) [@system](https://forum.knime.com/u/system)\
**Post date:** [October 19, 2024, 2:20pm UTC](https://forum.knime.com/t/appending-all-worksheets-in-excel-excel-file-into-1-master-worksheet/81181/4 "2024-10-19T14:20:16Z")

</div>

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
