Hub
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
  • KNIME Hub
  • Nodes
  • XLS Control Table Generator
NodeNode / Manipulator

XLS Control Table Generator

Community Nodes Continental XLS Formatter Control Table
Drag & drop
Like
Copy short link

The XLS Control Table Generator node takes an input data table and transforms it to an XLS Control Table, meaning it exchanges the column names to A, B, C, ... and the row IDs to 1, 2, 3, ... just like they would appear when opening the xlsx file in a spreadsheet application.

Optionally you can unpivot the table as well to make use of Rule Engine nodes later for flexible and dynamic XLS formatting workflows. A second operation type allows to pivot this special table layout back to the final desired XLS Control Table structure.

Node details

Input ports
  1. Type: Table
    Data Table
    Data table, typically holding the raw data of your xlsx sheet. Alternatively, the output of a previous instance of this node (in 'unpivot' mode) with the purpose to be pivoted back to wide table layout.
Output ports
  1. Type: Table
    Control Table
    The generated XLS Control Table (or its unpivoted version).

Extension

The XLS Control Table Generator node is part of this extension:

  1. Go to item

Related workflows & nodes

  1. Go to item
    02 - create control table for tagging
    kowisoft > Public > Continental XLS Formatter Tutorial > 02 - create control table for tagging
  2. Go to item
    03 - rule engine
    kowisoft > Public > Continental XLS Formatter Tutorial > 03 - rule engine
  3. Go to item
    11_XLS_CellCommenter
    knime > Examples > 99_Community > 05_Continental_Nodes_for_KNIME > 02_XLS_Formatter > 01_Tutorials > 11_XLS_CellCommenter
  4. Go to item
    04 - create control table for formatting
    kowisoft > Public > Continental XLS Formatter Tutorial > 04 - create control table for formatting
  5. Go to item
    WritingFormatedExcel
    ana_ved > Public > WritingFormatedExcel
  6. Go to item
    00_Installing_Extensions
    Education
    Open this workflow to install all required extensions for this course.
    knime > Education > Courses > L1-DW KNIME Analytics Platform for Data Wranglers - Basics > Installing_Extensions
  7. Go to item
    00_Installing_Extensions
    Education
    Open this workflow to install all required extensions for this course.
    schunwick > Public > Installing_Extensions
  8. Go to item
    00_Installing_Extensions
    Education
    Open this workflow to install all required extensions for this course.
    scottf > Public > L1-DW Version 4.3 > Installing_Extensions
  9. Go to item
    00_Installing_Extensions
    Education
    Open this workflow to install all required extensions for this course.
    ztgadmin > Public > L1-DW KNIME Analytics Platform for Data Wranglers - Basics > Installing_Extensions
  10. Go to item
    06_XLS_CellMerger
    This example workflow is licensed under the MIT License. See LICENSE.txt in the workflow …
    knime > Examples > 99_Community > 05_Continental_Nodes_for_KNIME > 02_XLS_Formatter > 01_Tutorials > 06_XLS_CellMerger

No known nodes available

KNIME
Open for Innovation

KNIME AG
Hardturmstrasse 66
8005 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • E-Learning course
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • KNIME Open Source Story
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more on KNIME Server
© 2022 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Credits