Table To Excel Cell Updater

This node transforms each cell of the input table to the required format by the Excel Cell Updater Node.
Each cell will be returned as a new row with the needed Excel cell address

Options

Offsets
Select how many columns/rows you want to skip for the cell update E.g. if you want to write the first cell of the input KNIME table to Excel cell A2 you will have to offset rows by 1. If you want to shift this by 2 rows and 1 column (so starting at B3): Row offset: 2 Column offset: 1
Cell addresses
Select if you want to output the addresses in Excel cell format or as numeric format
Ignore Missing Cells?
Check this if you do not want to output missing cell values

Input Ports

Icon
Table that contains all cells of the input table as rows with the corresponding excel cell address Each different type of the input table will get an extra column with the values of the input table

Output Ports

Icon
No description for this port available.

Views

This node has no views

Workflows

  • No workflows found

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.