Icon

FlowVariableAsOutputFilenameXLSFormatter

Flow Variable As Output Filename for XLS Formatter
Demo of using java edit variable to add a flow variable as a relativefile path without using knime:// relative paths.7 April 2021 @takbb Brian Batescreated to assist with https://forum.knime.com/t/xls-formatter-apply/31976 Some thrown together XLS formatter stuff. Not designed to work particularly, but justproves the concept. This bit here is the important bit for thisdemo - i.e. the following two nodes:Extract Context PropertiesJava Edit Variable.Between them they create a relative pathString flow variable to be used by XLSFormatter 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 dataApply formattingNode 16Node 17Node 18Collect workflow context informationDefine an outputfile stringflow variablerelative relative to workflow Excel Writer String to Path(Variable) Table Rowto Variable Table Creator Table Creator XLS Formatter(apply) XLS ControlTable Generator XLS ConditionalFormatter XLS Font Formatter Extract ContextProperties Java Edit Variable Demo of using java edit variable to add a flow variable as a relativefile path without using knime:// relative paths.7 April 2021 @takbb Brian Batescreated to assist with https://forum.knime.com/t/xls-formatter-apply/31976 Some thrown together XLS formatter stuff. Not designed to work particularly, but justproves the concept. This bit here is the important bit for thisdemo - i.e. the following two nodes:Extract Context PropertiesJava Edit Variable.Between them they create a relative pathString flow variable to be used by XLSFormatter 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 dataApply formattingNode 16Node 17Node 18Collect workflow context informationDefine an outputfile stringflow variablerelative relative to workflowExcel Writer String to Path(Variable) Table Rowto Variable Table Creator Table Creator XLS Formatter(apply) XLS ControlTable Generator XLS ConditionalFormatter XLS Font Formatter Extract ContextProperties Java Edit Variable

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: 2021-04-07
Last update: 2024-04-29
Created with KNIME version: v4.3.2
Tags: Flow VariableExcel WriterPathString to Path (Variable)relative pathXLS Formatter

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

Try NodePit Runner!