How to pass Excel reader output as an input to xls formatter node

[BAVITHRA]

Hello
This is a part of my workflow where i want to take the output of excel writer and give it as a input to xls formatter node.
Because when specifying input file location for xls formatter (apply) nodeI dont want to select a file from local file manager instead i would like to take it directly from the excel writer node that is placed and executed before the xls formatter node.

(Output generated from excel writer is an unformatted file )

[ipazin]

Hello @BAVITHRA,

in Excel Writer create flow variable holding location where Excel file is written and then use it in XLS Formatter node.

Br,
Ivan

[mlauber71]

@BAVITHRA ist does look like this:

Input file name to output file name

@johnnybasha you can capture the file name given (or it might come as an already existing Path variable) maybe from a List Files/Folders – KNIME Hub node. [image] You can separate the File Nam from the extension so you might create a new file name with a different extension in a Java Edit node or directly create a new Path variable. [image] kn_example_path_name_file.knwf (34.2 KB)