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