Icon

Excel - Formula Apache POI - OpenPyxl

<p>KNIME and advanced Excel Formulas - OpenPyxl vs. Apache POI</p>

URL: KNIME Community - KNIME and Excel Apache POI https://community.knime.com/c/ask-the-community/knime-dealing-with-excel-files-apache-poi#comment_wrapper_107098018?u=mlauber71

KNIME and advanced Excel Formulas - OpenPyxl vs. Apache POI

https://community.knime.com/c/ask-the-community/knime-dealing-with-excel-files-apache-poi#comment_wrapper_107098018?u=mlauber71

path extension:_openpyxl_knime_poi
Expression
Table Row to Variable
Recalculate Excel
URL to File Path
Excel Cell Updater
manipulateExcel Cells usingOpenPyxlfrom the input table
Python Script
input tablewhat Excel values tochange
Table Creator
adapted from a component by takbb to re-calculate formulas in Excel(see inside for details)
Recalc Excel for KAP5.x
input tablewhat Excel values tochange
Table Creator
locate and create /data/ folder with absolute paths
Collect Local Metadata
excel_file_path
String to Path
"Lookup"sheet
Excel Reader
copy filefor use withOpenPyxl
Transfer Files (Table)
Table Row to Variable
openpyxl_file_path
String to Path
importusing OpenPyxl=> if the Excel File has not beensaved outside KNIMEthe formulas will not have updated values
Python Script
Python Script
Column Filter
"Lookup"sheet
Excel Reader
String to URI
knime_poi_file_path
String to Path
copy File for use withExcel Cell Updater
Transfer Files (Table)
file_path
Variable Creator

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: m_lauber
Created at: 2026-06-19
On NodePit since: 2026-06-20
Last update: 2026-06-21
Created with KNIME version: v5.11.1
Tags: ExcelPOIApacheOpenPyxl

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!