# Data extraction from .xls file/s

**URL:** <https://forum.knime.com/t/data-extraction-from-xls-file-s/29528>\
**Category:** KNIME Analytics Platform\
**Created:** [December 17, 2020, 9:53am UTC](https://forum.knime.com/t/data-extraction-from-xls-file-s/29528 "2020-12-17T09:53:18Z")\
**Posts on this page:** 1\
**Showing post:** 12

<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:** [December 18, 2020, 4:54pm UTC](https://forum.knime.com/t/data-extraction-from-xls-file-s/29528/12 "2020-12-18T16:54:38Z")

</div>

@Matt9301 there is a way to do this with the use of [Python](https://medium.com/low-code-for-advanced-data-science/knime-and-python-setting-up-and-managing-conda-environments-2ac217792539) pandas and [openpyxl](https://openpyxl.readthedocs.io/en/stable/)

 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/4/5/455571e736ee0e4958e5fc07f4c7b4f3b9456697.png)

You would have to provide an existing excel file and a sheet name and then sheets with the same structure.

 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/0/c/0cb80780907f5204ad8b57ee66e94be8b0668c49.png)

> **[Append data to an existing Excel file with the help of Python Pandas and...](https://hub.knime.com/mlauber71/spaces/Public/forum/kn_forum_29528_python_excel_append_to_existing_sheet~n3hrmW89qQRj3rg0/current-state)**
>
> Append data to an existing Excel file with the help of Python Pandas and OpenPyxl

–  
Edit: [KNIME and Excel — An Overview of What You Can Do | by Markus Lauber | Low Code for Data Science | Medium](https://medium.com/low-code-for-advanced-data-science/knime-and-excel-an-overview-of-what-you-can-do-c6d400319745)

---

_[View the full topic](https://forum.knime.com/t/data-extraction-from-xls-file-s/29528)._
