# Excel Reader - How to retain empty cells?

**URL:** <https://forum.knime.com/t/excel-reader-how-to-retain-empty-cells/61674>\
**Category:** KNIME Analytics Platform\
**Tags:** excel\
**Created:** [February 13, 2023, 10:08pm UTC](https://forum.knime.com/t/excel-reader-how-to-retain-empty-cells/61674 "2023-02-13T22:08:06Z")\
**Posts on this page:** 1\
**Showing post:** 24

<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:** [February 15, 2023, 4:09pm UTC](https://forum.knime.com/t/excel-reader-how-to-retain-empty-cells/61674/24 "2023-02-15T16:09:37Z")

</div>

@LB_Knime the OpenPyxl is quite easy to use in case someone sees this thread in the future. It basically works like this:

```auto
import knime.scripting.io as knio
import pandas as pd

v_excel_file = knio.flow_variables['file_path']
v_name_sheet = knio.flow_variables['Name_Excel_sheet']

df = pd.read_excel(v_excel_file, sheet_name=v_name_sheet, engine='openpyxl')

knio.output_tables[0] = knio.Table.from_pandas(df)

```

> **[Import Excel File with OpenPyxl (simple) – mlauber71](https://hub.knime.com/mlauber71/spaces/Public/latest/kn_example_python_excel_import_simple_file_openpyxl~gtHNLTIhu-uTNuDa)**
>
> Import Excel File with OpenPyxl (simple)

---

_[View the full topic](https://forum.knime.com/t/excel-reader-how-to-retain-empty-cells/61674)._