# EXCEL WRITER NODE-VARIABLE ISSUE

**URL:** <https://forum.knime.com/t/excel-writer-node-variable-issue/29946>\
**Category:** KNIME Analytics Platform\
**Created:** [January 14, 2021, 1:47pm UTC](https://forum.knime.com/t/excel-writer-node-variable-issue/29946 "2021-01-14T13:47:46Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Antonio965](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/a/b5a626/32.png) [@Antonio965](https://forum.knime.com/u/Antonio965)\
**Post date:** [January 14, 2021, 1:47pm UTC](https://forum.knime.com/t/excel-writer-node-variable-issue/29946/1 "2021-01-14T13:47:46Z")

</div>

Hello everyone,  
I’m trying to export a large amount of data into several excel files (one for each customer) trough a loop. therefore, I created a file path where only the customer’s name changes. However, within the excel writer node I am not able to select the variable I created in the “file” field. Thanks in advance for the help.

 ![Capture](https://forum-cdn.knime.com/uploads/default/original/3X/2/d/2d98ad859dd1f48a3ede59fbdddf29b439189462.png)  
 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/d/2/d2ce3735988621b4945f10c20761f1db574c1e34.png)

---

<div class="post-metadata">

**Author:** ![iperez](https://forum-cdn.knime.com/user_avatar/forum.knime.com/iperez/32/24881_2.png) [@iperez](https://forum.knime.com/u/iperez)\
**Post date:** [January 14, 2021, 2:15pm UTC](https://forum.knime.com/t/excel-writer-node-variable-issue/29946/2 "2021-01-14T14:15:16Z")

</div>

Hi @Antonio965 welcome to the forum. To me it looks like the flow is OK. Could you post it with dummy data to check it in detail?

---

<div class="post-metadata">

**Author:** ![ScottF](https://forum-cdn.knime.com/user_avatar/forum.knime.com/scottf/32/61316_2.png) [@ScottF](https://forum.knime.com/u/ScottF)\
**Post date:** [January 14, 2021, 2:31pm UTC](https://forum.knime.com/t/excel-writer-node-variable-issue/29946/3 "2021-01-14T14:31:30Z")

</div>

Hi @Antonio965 and welcome to the forum.

(Moving this thread to the Analytics Platform topic since it seems like more of a general AP issue.)

I think what you need here is a [String to Path (Variable)](https://kni.me/n/ZQhbBU6AJWXWZgxn) node just before the Excel Writer. The new file handling in v4.3 has a new type of flow variable, called a _path variable_, that is needed here. Read more in this blog post (in the “Utility Nodes” section):

> **[New File Handling Out of Labs and Into Production | KNIME](https://www.knime.com/blog/new-file-handling-out-of-labs-and-into-production)**
>
> As of KNIME Analytics Platform 4.3 the updated and improved File Handling framework has moved out of Labs into Production. What motivated the change and what are the benefits?

Hope that helps.

---

<div class="post-metadata">

**Author:** ![Antonio965](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/a/b5a626/32.png) [@Antonio965](https://forum.knime.com/u/Antonio965)\
**Post date:** [January 14, 2021, 2:49pm UTC](https://forum.knime.com/t/excel-writer-node-variable-issue/29946/4 "2021-01-14T14:49:16Z")

</div>

Hello @ScottF thank you very much for your tip. I tried and it works now.

---

<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:** [January 21, 2021, 2:49pm UTC](https://forum.knime.com/t/excel-writer-node-variable-issue/29946/5 "2021-01-21T14:49:21Z")

</div>

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