- Type: TableData TableThe source data table used to generate the XLS Control Table
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
- Type: TableData PassthroughThis is the data as input, for easy linking to the XLS File Writer. The port is supplied to help keep workflows tidy.
- Type: TableXLS Control TableAn XLS Control Table using default settings for the XLS Control Table Generator. (This replaces the need to use XLS Control Table Generator)
- Type: XLS FormatterXLS 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
Used extensions & nodes
Created with KNIME Analytics Platform version 4.7.7
By using or downloading the component, you agree to our terms and conditions.