# 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:** 1\
**Showing post:** 3

<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.

---

_[View the full topic](https://forum.knime.com/t/appending-all-worksheets-in-excel-excel-file-into-1-master-worksheet/81181)._
