Icon

Excel - Date Cell - Update

<p>Use AF Utility Nodes to update Date / Time Cells in KNIME and update the results in Excel</p>

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

Use AF Utility Nodes to update Date / Time Cells in KNIME and update the results in Excel
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

Use AF Utility Nodes

for several useful Excel manipulations

https://hub.knime.com/e/DV7CzBPHtd269EQn

Blog: KNIME - Cases, Switches and Catching Errors

https://medium.com/p/5ab748cbeaa3

Use KNIME Excel Cell updater to fill in new values

yyyy-MM-dd['T'][' ']HH:mm[:ss[.SSS]]
String to Date&Time
/data/date_sample.xlsxforce recalculation of formulas
Excel Reader
Write To Excel Template
v_select_port
Java Edit Variable (simple)
String to Date&Time
excel addresses in A21 ... styleactivate offset
Table To Excel Cell Updater
Extract Table Spec
Cell Splitter
locate and create /data/ folder with absolute paths
Collect Local Metadata
add the column nameto the Excel address
Joiner
Cell Updater
$Column Index$+1
Math Formula
Column Filter
Excel Cell Updater
Python Script
Excel addresses in column number : row numberstyle(will need this later for updating individual cells in KNIME)
Table To Excel Cell Updater
shift dates 2 years back
Date Shifter
String to URI
sample10 lines to change the valuein
Row Sampler
not missing
Row Filter
Table Row to Variable
Joiner
URL to File Path
Reference Row Filter
String to Path (Variable)
shift dates 2 years back
Date Shifter
Table Row to Variable Loop Start
Cell Splitter
_temp.table
Table Reader
Date&Time to String
CASE Switch End
_temp.tablewrite after change
Table Writer
_temp.table=> make sure to reset this
Table Writer
_temp.table
Table Reader
CASE Switch Start
Variable Loop End

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-06-22
Last update: 2026-06-22
Created with KNIME version: v5.11.1
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!