Hub
NodeNode / Source

Evaluate Excel Formula

Community Nodes AF Utilities ExcelUtil
Drag & drop
Like
Copy short link

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

Node details

Input ports
  1. Type: Table
    In-Port name
    table to consider for excel formula - including formula cell
Output ports
  1. Type: Table
    Out-Port name
    input table with an additional evaluated column

Extension

The Evaluate Excel Formula node is part of this extension: