Icon

FlowVariableAsOutputFilenameXLSFormatter Simplified

Flow Variable As Output Filename for XLS Formatter (Simplified)
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. Update 16 July 2021Modified to use my Open File or Folder component which creates therequired Path, String and URL versions of the variable so that thesame file name can be passed to both old-style and new-style filehandling components. See help documentation for Open File orFolder component Excel writer can now get path from a flow variable as it is a "path" type variableThis is using the outputXlsxName_path variablePut the path string into a variableSome sample data to be written to Excel fileconfig dataApply formattingThis is using the outputXlsxName variableNode 16Node 17Node 18 Open File or Folder Excel Writer Table Rowto Variable Table Creator Table Creator XLS Formatter(apply) XLS ControlTable Generator XLS ConditionalFormatter XLS Font 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. Update 16 July 2021Modified to use my Open File or Folder component which creates therequired Path, String and URL versions of the variable so that thesame file name can be passed to both old-style and new-style filehandling components. See help documentation for Open File orFolder component Excel writer can now get path from a flow variable as it is a "path" type variableThis is using the outputXlsxName_path variablePut the path string into a variableSome sample data to be written to Excel fileconfig dataApply formattingThis is using the outputXlsxName variableNode 16Node 17Node 18Open File or Folder Excel Writer Table Rowto Variable Table Creator Table Creator XLS Formatter(apply) XLS ControlTable Generator XLS ConditionalFormatter XLS Font Formatter

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-07-21
Last update: 2024-11-21
Created with KNIME version: v4.3.4
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!