0 ×

XLS Formatter (apply)

Continental Nodes for KNIME version 1.2.0.v202005250952 by Continental

The XLS Formatter (apply) node applies the chained commands from XLS Formatter nodes to an unformatted xlsx file.

All previous XLS Formatter nodes do not modify any xlsx files yet but prepare the formatting steps to be taken here. The input file may not contain any formatting yet (except very few styles that are tolerated due to date/time values handling).

Options

IO Options

Input File: File-path of your raw input xlsx file.
Output File: File-path of your formatted output xlsx file.

Advanced Options

overwrite output file: If a file already exists in the output directory the file will either be over-written or an error will be generated.
open output file after execution: Once the node execution has been finished, the output xlsx file will be opened.

Input Ports

: The XLS Formatter input port holding the collected formatting instructions for your xlsx file.

Best Friends (Incoming)

~~Excel Writer (XLS)~~ (25 %) Deprecated
~~Excel Writer (XLS)~~ (11 %) Deprecated
XLS Background Colorizer (9 %)
XLS Cell Formatter (8 %)
XLS Border Formatter (7 %)
Show all 32 recommendations

Best Friends (Outgoing)

Workflows

Installation

To use this node in KNIME, install Continental Nodes for KNIME from the following update site:

KNIME 4.3

A zipped version of the software site can be downloaded here.

You don't know what to do with this link? Read our NodePit Product and Node Installation Guide that explains you in detail how to install nodes to your KNIME Analytics Platform.

Wait a sec! You want to explore and install nodes even faster? We highly recommend our NodePit for KNIME extension for your KNIME Analytics Platform. Browse NodePit from within KNIME, install nodes with just one click and share your workflows with NodePit Space.

Developers

You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.