Evaluate Excel Formula

This node evaluates a selected column with Excel formulas
All columns of the input table will be considered in the formula evaluation.
Formula should start with equal sign (=) and should be in the English format e.g. =SUM(A1:A9)
The formula result will be returned as a string column
All string columns starting with an equal sign (=) will be considered as formulas as well

Options

formula column to evaluate
Select the column you want to evaluate Should start with equal sign

Input Ports

Icon
table to consider for excel formula - including formula cell

Output Ports

Icon
input table with an additional evaluated column

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.