Icon

FlowVariableAsOutputFilename Several Sheets

Flow Variable As Output Filename for Excel Writer

Simple demonstration of using a file name in a flow variable as the output file name on Excel Writer. The flow variable must be a "path" type variable, and not just a string containing a path, so the String to Path (variable) node converts the file name into the required format.

Simple demonstration of using a file name in a flow variable as theoutput file name on Excel Writer. The flow variable must be a "path"type variable, and not just a string containing a path, so the String toPath (variable) node converts the file name into the required format. 3 April 2021 @takbb Brian Batescreated to assist with https://forum.knime.com/t/flow-variables-usage-excel-writer-filename/31935/3 Modified: Just want to write several sheets into a file in an specific location Excel writer can now get path from a flow variable as it is a "path" type variableconvert the string variable into a pathPut the path string into a variableSome sample data to be written to Excel fileconfig dataconvert the string variable into a pathC:\Users\MAURICIO\Desktop\File.xlsx01 First SheetSome sample data to be written to Excel fileWrite a file calledfile into C:\Put the path string into a variable02 Second Sheet Excel Writer String to Path(Variable) Table Rowto Variable Table Creator Table Creator String to Path(Variable) Excel Writer Table Creator Table Creator Table Rowto Variable Excel Writer Simple demonstration of using a file name in a flow variable as theoutput file name on Excel Writer. The flow variable must be a "path"type variable, and not just a string containing a path, so the String toPath (variable) node converts the file name into the required format. 3 April 2021 @takbb Brian Batescreated to assist with https://forum.knime.com/t/flow-variables-usage-excel-writer-filename/31935/3 Modified: Just want to write several sheets into a file in an specific location Excel writer can now get path from a flow variable as it is a "path" type variableconvert the string variable into a pathPut the path string into a variableSome sample data to be written to Excel fileconfig dataconvert the string variable into a pathC:\Users\MAURICIO\Desktop\File.xlsx01 First SheetSome sample data to be written to Excel fileWrite a file calledfile into C:\Put the path string into a variable02 Second SheetExcel Writer String to Path(Variable) Table Rowto Variable Table Creator Table Creator String to Path(Variable) Excel Writer Table Creator Table Creator Table Rowto Variable Excel Writer

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: brian
Created at: 2021-04-03
On NodePit since: 2022-02-06
Last update: 2024-05-02
Created with KNIME version: v4.4.0
Tags: Flow VariableExcel WriterPathString to Path (Variable)

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!