XLS Control Table from Cell Range

The XLS Control Table from Cell Range node creates a control table based on a cell range and a tag you can specify in the node dialog.

Optionally you can input another control table whose cells will be either overwritten or appended to by the new tag.

Options

Cell range
Cell range in XLS format (e.g. A2 or A2:B10) for which the tag should be created. Also supports the numeric column addressing format of R1C1 or R1C1:R2C2 where 'R' is the row number and 'C' the column number.
Tag to set in control table
Tag that shall be set for the cells of your range specified before.
Tag combination mode
If the optional control table input is used, you can either overwrite or append the tag for overlapping cells.

Input Ports

Icon
Previous XLS Control Table that shall be enriched by further tags.

Output Ports

Icon
Enriched XLS Control Table.

Popular Predecessors

  • Excel Writer (XLS)8 %
  • Wait...4 %
  • Table Row To Variable Loop Start4 %
  • XLS Control Table Generator3 %
  • Table Creator3 %
  • Missing Value3 %
  • Sorter3 %
  • Pivoting3 %
  • Python Script3 %
  • Image Writer (Table)3 %
  • Variable Creator2 %
  • Group Loop Start2 %
  • Extract Column Header2 %
  • String Manipulation2 %
  • Rule-based Row Filter2 %
  • Row Splitter2 %
  • XLS Control Table from Cell Range2 %
  • XLS Control Table Merger2 %
  • Column Filter2 %
  • String Manipulation (Variable)2 %
  • Column Expressions2 %
  • XLS Sheet Selector2 %
  • Table Column to Variable2 %
  • Table Row to Variable2 %
  • Concatenate2 %
  • Column Auto Type Cast2 %
  • Row Filter2 %
  • Rule Engine2 %
  • Variable Expressions2 %
  • Excel Reader2 %
  • Excel Writer2 %
  • Top k Selector2 %
  • Number To String2 %
  • Constant Value Column1 %
  • Reference Row Filter1 %
  • GroupBy1 %
  • Column Resorter< 1 %
  • Column Splitter< 1 %
  • Excel Sheet Appender (XLS)< 1 %
  • Column Rename< 1 %
  • Table Row to Variable< 1 %
  • Table Row to Variable< 1 %
  • Table Row To Variable Loop Start< 1 %
  • Variable to Table Row< 1 %
  • File Reader< 1 %
  • Table Reader< 1 %
  • Loop End< 1 %
  • Recursive Loop Start< 1 %
  • Variable Loop End< 1 %
  • Number To String< 1 %
  • Reference Column Resorter< 1 %
  • Regex Split< 1 %
  • Extract Table Dimension< 1 %
  • Merge Variables< 1 %
  • Excel Reader (XLS)< 1 %
  • Excel Reader (XLS)< 1 %
  • Scatter Plot< 1 %
  • Java Edit Variable< 1 %
  • Java Snippet< 1 %
  • Column Aggregator< 1 %
  • Table Manipulator< 1 %
  • RowID< 1 %
  • Ungroup< 1 %
  • Rule Engine Variable< 1 %
  • String to Path (Variable)< 1 %

Views

This node has no views

Workflows

Links

Developers

You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.