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
Options
Output Ports
- This is the data as input, for easy linking to the XLS File Writer. The port is supplied to help keep workflows tidy.
- An XLS Control Table using default settings for the XLS Control Table Generator. (This replaces the need to use XLS Control Table Generator)
- (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
Nodes
- Transpose12 ×
- String Manipulation9 ×
- Column Filter7 ×
- XLS Control Table Generator4 ×
- Column Appender3 ×
- Show all 33 nodes
Extensions
- FeatureContinental Nodes for KNIME
- FeatureKNIME Base nodes
- FeatureKNIME Data Generation
- FeatureKNIME Javasnippet
- FeatureKNIME Math Expression (JEP)
- Show all 6 modules
Links
- No links available