Hub
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
  • KNIME Hub
  • Nodes
  • Evaluate Excel Formula
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:

  1. Go to item

KNIME
Open for Innovation

KNIME AG
Hardturmstrasse 66
8005 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • E-Learning course
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • KNIME Open Source Story
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more on KNIME Server
© 2022 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Credits