The XLS Formatter nodes make it possible to add formatting and advanced settings to.xlsx files.
For details regarding the individual nodes, please also refer to the node descriptions within KNIME. This documentation page is rather intended as an overview, not as
The XLS Formatter nodes make it possible to add formatting and advanced settings to.xlsx files.
For details regarding the individual nodes, please also refer to the node descriptions within KNIME. This documentation page is rather intended as an overview, not as a repetition or replacement of the node descriptions. Additionally, there is a Frequently Asked Questions page regarding the XLS Formatter nodes.
XLS Formatting Concept
Figure 1 shows the concept behind the XLS Formatting nodes based on an example. The logical flow of this explanation follows the numbers (1) to (11) in the graphic.
An input table (1) needs to be written to an.xlsx file first (2). Our XLS Formatting concept only adds formatting on top of existing files that contain all content. The XLS Formatter (apply) node fulfills this task and applies collected formatting instructions to a target file (3). The flow variable connection between (2) and (3) can serve the purpose to transmit file destinations, but it is particularly important to establish a precondition: The XLS Formatter (apply) node may only start execution when its predecessor node has successfully written the file.
The inport of XLS Formatter (apply) is an own port type, displayed as a green square. This XLS Formatter type carries formatting instructions (4). You can imagine them as a stack of paper, holding a different instruction each. These instructions are generat