XLS Control Table Auto Tag Generator

XLS Control Table Auto-Tag Generator

Use this in conjunction with the Continental Nodes to directly generate a control table populated with tags based on data types from a source data table.

The output port provides a generated control table containing multiple comma-delimited tags that can be used directly with the XLS formatter nodes.

The XLS Formatter nodes are from the Continental Nodes and are as described in the Continental documentation.

The generated tags take the following format:

Header Row Tags: h:Column Name, header th:data type, c:Column Name
Body Row Tags: d:Column Name, data, t:data type, c:Column Name

Banding Tags: band:odd band:even
(denotes if data row is an odd or even number)

[b]Freeze Tags[/b]: freezerow1, freezecol1, feezepanes can be used to freeze just header, column 1 or both

The prefixes were chosen to mean the following:
h: This is a header row for the given Column Name
d: This is a data row for the given Column Name
t: This is a body row of a specific data type
c:This a a cell in a given column name (header or data)

It is therefore then possible to set all headers to a particular format by referencing the header tag but to affect the formatting of a specfic column header by using the h:Column Name tag e.g. h:Customer Name

Likewise the body (data) rows can be formatted in their entirety by referencing the data tag, or all String body rows can be referenced using t:String

Please contact me via the KNIME forum if you have any comments, run into any problems, or can think of improvements are other auto tags that you think would be generally useful.

@takbb Brian Bates

26 September 2022
Updated 28 September 2022 - additional of optional XLS Formatter output node
Updated 31 October 2022 - minor bug fix to control table, and correction to documentation

Input ports

1. Type: Table
   Data Table
   The source data table used to generate the XLS Control Table

Output ports

1. Type: Table
   Data Passthrough
   This is the data as input, for easy linking to the XLS File Writer. The port is supplied to help keep workflows tidy.
2. Type: Table
   XLS Control Table
   An XLS Control Table using default settings for the XLS Control Table Generator. (This replaces the need to use XLS Control Table Generator)
3. Type: XLS Formatter
   XLS Formatter
   (Optional) output port. This provides a basic default format for the first sheet. You can join this directly to an XLS Formatter (apply) node, or chain it to XLS Formatter Template component, or other XLS Formatter nodes