# Read from Excel Table

**URL:** <https://forum.knime.com/t/read-from-excel-table/38190>\
**Category:** Feedback & Ideas\
**Tags:** feature-request\
**Created:** [December 13, 2021, 3:46pm UTC](https://forum.knime.com/t/read-from-excel-table/38190 "2021-12-13T15:46:38Z")\
**Posts on this page:** 1\
**Showing post:** 8

<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 14, 2021, 3:06pm UTC](https://forum.knime.com/t/read-from-excel-table/38190/8 "2021-12-14T15:06:54Z")

</div>

@Experteece actually you can use [Python](https://hub.knime.com/mlauber71/spaces/Public/latest/_knime_and_python_meta_collection~AvjrddXKOIoZYLV3) and [openpyxl](https://hub.knime.com/mlauber71/spaces/Public/latest/kn_example_python_excel_manipulate/kn_python_excel_manipulate~tzlXBcZi8qneNE0a) with KNIME to do that. Identify named tables and import them (cf. [this thread](https://stackoverflow.com/questions/69255564/how-to-extract-different-tables-in-excel-sheet-using-python)).

 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/4/7/47716248817a67dc40cfca75fa9afd92de96ab89.png)

You van extract the tables directly or read all the ranges from your ‘named’ table (areas) and then use KNIME to import them.

 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/7/7/77bdb82c502e4c9da3ddc63ec0da6642127e647c.png)

> **[KNIME and Python's openpyxl to extract names tables (ranges) from Excel file...](https://hub.knime.com/mlauber71/spaces/Public/latest/kn_example_python_excel_table_object_read~6vIqAiYaOGUNuBMJ)**
>
> KNIME and Python's openpyxl to extract names tables (ranges) from Excel file

---

_[View the full topic](https://forum.knime.com/t/read-from-excel-table/38190)._