Icon

Excel - Date Formula in Cell

<p>Import Excel Sheet with formulas</p>

URL: Hub: Excel - OpenPyxl Save and Read Files https://hub.knime.com/s/xeY7qdZNeXk8I-i0

Import Excel Sheet with formulas
KNIME and Excel — An Overview of What You Can Do

https://medium.com/p/c6d400319745

How to Set Up Your Python Extensions

https://www.knime.com/blog/how-to-setup-the-python-extension

/data/date_sample.xlsxforce recalculation of formulas
Excel Reader
Date&Time Part Extractor
Table Row to Variable
=> import Excel sheet with openpyxlimport cached formula results
Python Script
Path to String (Variable)
file_path
URL to File Path (Variable)
=> import Excel sheet with openpyxl
Python Script
var_sheet_name
String Configuration
data_folder
List Files/Folders

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: A9699459
Created at: 2026-05-13
On NodePit since: 2026-05-14
Last update: 2026-05-14
Created with KNIME version: v5.11.0
Tags: Excelimportformulaopenpyxl

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

Try NodePit Runner!