# Writer Node Issues

**URL:** <https://forum.knime.com/t/writer-node-issues/44776>\
**Category:** KNIME Analytics Platform\
**Created:** [July 5, 2022, 9:03am UTC](https://forum.knime.com/t/writer-node-issues/44776 "2022-07-05T09:03:46Z")\
**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:** [July 5, 2022, 9:49am UTC](https://forum.knime.com/t/writer-node-issues/44776/2 "2022-07-05T09:49:18Z")

</div>

@helpmeplease if you want the structure of your Excel file unchanged and just change values there are these options, if you must change data on a pre-formatted sheet (otherwise you might just replace this sheet). The Excel Cell Updater can change values in specific cells.

> **[Excel Cell Updater](https://hub.knime.com/knime/extensions/org.knime.features.ext.poi/latest/org.knime.ext.poi3.node.io.filehandling.excel.updater.cell.ExcelCellUpdaterNodeFactory)**
>
> This node updates cells in an existing Excel spreadsheet. The cell addresses and their new content are supplied by an input data table. Adding additional table…

> **[Excel Sheet Updater – lukass](https://hub.knime.com/lukass/spaces/Forum/Excel%20Sheet%20Updater~f6cAiYb-jgwFtouG/current-state)**
>
> Solutions for data science: find workflows, nodes and components, and collaborate in spaces.

You can use a community node to write to an Excel file without changing the structure or formats:

> **[Write To Excel Template (deprecated)](https://hub.knime.com/anotherfrauduser/extensions/org.anotherfraud.excel.feature/latest/org.AF.ExcelUtilities.WriteToExcelTemplate.WriteToExcelTemplateXLSXNodeFactory)**
>
> This node writes the input data table into an existing Excel file without changing its formatting. Alternatively a new file will be created based on the templa…

> [@Problem with AF Utilities "Write to Excel Template" node](https://forum.knime.com/t/problem-with-af-utilities-write-to-excel-template-node/37567):
>
> Hi, we’re using AF Utilities “Write to Excel Template” node from @AnotherFraudUser to write some data to some heavily formatted excel files that our users want to keep the way they are. Our problem is that when the output file path is set to “Relative” it looks like the node adds a prefix to the value that we set, specifically “\\<flow name\>\”, thus making the path invalid. Attached is a sample workflow that copies a template file from the input data folder (also attached) to a temp directory …

You can the use [Python](https://kni.me/w/AvjrddXKOIoZYLV3) and [OpenPyxl](https://hub.knime.com/search?q=openpyxl&type=Workflow&tag=openpyxl,excel&sort=best) to do more complex editings of excel files. You will have to plan ahead what this does to you files.

> [@Data extraction from .xls file/s](https://forum.knime.com/t/data-extraction-from-xls-file-s/29528/12):
>
> @Matt9301 there is a way to do this with the use of [Python](https://hub.knime.com/mlauber71/spaces/Public/latest/_knime_and_python_meta_collection) pandas and [openpyxl](https://openpyxl.readthedocs.io/en/stable/) You would have to provide an existing excel file and a sheet name and then sheets with the same structure.

Otherwise you might indeed use the Continental Nodes to format your excel sheet after you have exported the data (this might be the safest option from a KNIME persspective).

> [@Excel Formating](https://forum.knime.com/t/excel-formating/44593/2):
>
> @helpmeplease welcome to the KNIME forum. I am not sure there is a consistent introduction about the [Continental nodes](https://hub.knime.com/continental_knime_extension_developer/extensions/com.continental.knime.feature/latest). I have [not done much with them](https://kni.me/w/FLsPoDBusoKLMTWb) but it seems you have to grasp the concept of this “[control table](https://kni.me/w/Lq4X1-_FKKDtlSTF)” it seems. Then there is the free book “From Excel to KNIME” which also has a chapter about Continental nodes. This also might be a good pint to start understanding the concept. the book is also available in other languages like German, Spanish and Portuguese: Ano…

---

_[View the full topic](https://forum.knime.com/t/writer-node-issues/44776)._
