# 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:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Mai\_Nashaat](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/m/8dc957/32.png) [@Mai\_Nashaat](https://forum.knime.com/u/Mai_Nashaat)\
**Post date:** [November 16, 2020, 7:33am UTC](https://forum.knime.com/t/format-table-when-using-table-writer-node/28739/1 "2020-11-16T07:33:13Z")

</div>

Hi all,

After using excel writer node it writes the data to excel file but I want it to be formatted as table .  
Any help how can I do this?

---

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

---

<div class="post-metadata">

**Author:** ![Daniel\_Weikert](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/d/e47c2d/32.png) [@Daniel\_Weikert](https://forum.knime.com/u/Daniel_Weikert)\
**Post date:** [November 16, 2020, 6:04pm UTC](https://forum.knime.com/t/format-table-when-using-table-writer-node/28739/3 "2020-11-16T18:04:18Z")

</div>

There are some KNIME extension excel nodes for formatting right? Maybe he can use one of them

---

<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, 9:12pm UTC](https://forum.knime.com/t/format-table-when-using-table-writer-node/28739/4 "2020-11-16T21:12:07Z")

</div>

@Daniel_Weikert yes there are the:

Continental Nodes for KNIME — XLS Formatter Nodes

> **[Continental Nodes for KNIME — XLS Formatter Nodes | KNIME](https://www.knime.com/community/continental-nodes-for-knime-xls-formatter)**
>
> The XLS Formatter nodes make it possible to add formatting and advanced settings to .xlsx files.
> 
> For details regarding the individual nodes, please also refer to the node descriptions within KNIME. This documentation page is rather intended as an...

But I have not yet seen a node that would create a genuine Exel table. Although you could add some filters to your table in Excel:

> **[02\_Pretty\_Table – Continental\_KNIME\_Extension\_Developer](https://hub.knime.com/knime/spaces/Examples/latest/99_Community/05_Continental_Nodes_for_KNIME/02_XLS_Formatter/02_Applications/02_Pretty_Table)**
>
> This example workflow is licensed under the MIT License. See LICENSE.txt in the workflow directory for details.

---

<div class="post-metadata">

**Author:** ![system](https://forum-cdn.knime.com/uploads/default/original/1X/ab3ccf34482a0329361734a18199390177204f15.png) [@system](https://forum.knime.com/u/system)\
**Post date:** [May 18, 2021, 9:12am UTC](https://forum.knime.com/t/format-table-when-using-table-writer-node/28739/5 "2021-05-18T09:12:19Z")

</div>

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.