Hello, I have a workflow where I have to generate report daily and the file name should be the date of execution. I have used date and time configuration node to get the execution date and string manipulation node to prepare the path. Here is my code for the string manipulation: string(“C://Users//nikhilci//Documents//Reports//” + “TransactionData” + $${Sdate-input}$$ + “.xlsx”) This statement works fine. When I use the string to path variable node, it gets converted into ‘FSLocationVariableType’ data type. For some reason, excel writer does not recognize this as a path due to which I’m not able to write it into the required excel sheet. Weirdly, this same ‘FSLocationVariableType’ works fine when I am using the excel reader node. Please suggest how to fix this or a workaround. Thanks in advance

Hello, I was using 5.2.5 version. I updated it to 5.2.6 and it works now. I’m not sure exactly what the reason is. I was trying to configure the file with date to an existing workflow. Maybe you have to replace the existing excel reader node with a new one and configure it. Maybe this is a bug?

Unable to use path variable to write into excel

KNIME Analytics Platform

mlauber71 April 22, 2025, 3:57pm 4

@nikhil_benny you can create file path in a node. You can combine the names of the files with current time stamps.

1 Like