XLS Control Table Generator

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.

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).