# format table when using table writer node

**URL:** <https://forum.knime.com/t/format-table-when-using-table-writer-node/28739>\
**Category:** KNIME Analytics Platform\
**Created:** [November 16, 2020, 7:33am UTC](https://forum.knime.com/t/format-table-when-using-table-writer-node/28739 "2020-11-16T07:33:13Z")\
**Posts on this page:** 1\
**Showing post:** 2

<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:** [November 16, 2020, 4:37pm UTC](https://forum.knime.com/t/format-table-when-using-table-writer-node/28739/2 "2020-11-16T16:37:02Z")

</div>

This is possible with the help of Python:

> [@Write KNIME table to Excel as table (proposal)](https://forum.knime.com/t/write-knime-table-to-excel-as-table-proposal/14044/10):
>
> OK I think now I get what you want. Yes it is possible to first save a table as a ‘pure’ excel file and then define a range as a table object “All” which you can later use to refer to it. In my example the no of lines that the object would have is assigned dynamically while the columns are fixed but one might also be able to change that to a dynamic setting. After the ‘raw’ KNIME export: After openpyxl got to work: (cf. [https://openpyxl.readthedocs.io/en/stable/…](https://openpyxl.readthedocs.io/en/stable/worksheet_tables.html)

---

_[View the full topic](https://forum.knime.com/t/format-table-when-using-table-writer-node/28739)._