Hub
Pricing About
ComponentComponent

XLS Control Table Auto Tag Generator

takbb profile image
Draft Latest edits on 
Jan 15, 2024 10:04 AM
Drag & drop
Like
Use or download
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

Component details

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

Used extensions & nodes

Created with KNIME Analytics Platform version 4.7.7
  • Go to item
    Continental Nodes for KNIMETrusted extension

    Continental

    Version 1.4.0

    continental_knime_extension_developer
  • Go to item
    KNIME Base nodesTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.7.7

    knime
  • Go to item
    KNIME Data GenerationTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.7.0

    knime
  • Go to item
    KNIME JavasnippetTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.7.0

    knime
  • Go to item
    KNIME Math Expression (JEP)Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.7.0

    knime
  • Go to item
    KNIME Quick FormsTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.7.4

    knime

This component does not have nodes, extensions, nested components and related workflows

Legal

By using or downloading the component, you agree to our terms and conditions.

KNIME
Open for Innovation

KNIME AG
Talacker 50
8001 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • Courses + Certification
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more about KNIME Business Hub
© 2025 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Data Processing Agreement
  • Credits