Icon

Excel - OpenPyxl Save and Read Files

<p>Dynamically Read and Save Excel Files with OpenPyxl - create the Paths</p>

URL: How to Set Up Your Python Extensions https://www.knime.com/blog/how-to-setup-the-python-extension
URL: Hub: Export Excel File with OpenPyxl (simple) from KNIME - also add some formats https://hub.knime.com/s/R2klM6EM7t-JAwwR

You can dynamically determine the local user name. This can be useful if you for example want to create a Sharepoint or OneDrive path that often contains this information
Dynamically Read and Save Excel Files with OpenPyxl - create the Paths
How to Set Up Your Python Extensions

https://www.knime.com/blog/how-to-setup-the-python-extension
KNIME and Excel — An Overview of What You Can Do

https://medium.com/p/c6d400319745
data_folder
List Files/Folders
=> export to Excel File via Pythonconverting all Columns to strings
Python Script
Extract Context Properties
Variable to Table Row
context.workflow.username
Expression
String to Path
Path to String (Variable)
test2
Create File/Folder Variables
yyyy-MM-dd HH:mm:ss.SSSSSSXXX
String to Date&Time
test2.xlsx
Excel Reader
yyyy-MM-dd'T'HH:mm:ss.SSSVV'['zzzz']'
String to Date&Time
Column Auto Type Cast
file_path
URL to File Path (Variable)
Column Auto Type Cast
Column Filter
file_path
URL to File Path (Variable)
=> export to Excel File via Python
Python Script
Table Row to Variable
test3
Create File/Folder Variables
test3.xlsx
Excel Reader
Table Row to Variable
file_path
URL to File Path (Variable)
test1
Create File/Folder Variables
Path to String (Variable)
https://hub.knime.com/-/spaces/-/~4-Nz2crmY1OvrH_M/current-state/
Create Dummy Data
test1.xlsx
Excel Writer
Row Sampler
Path to String (Variable)
=> import Excel sheet with openpyxl
Python Script
var_sheet_name
String Configuration

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: 2025-08-27
On NodePit since: 2025-08-29
Last update: 2025-08-29
Created with KNIME version: v5.6.1
Tags: usersharepointoneDrivePathExcelOpenPyxlImportexportuser.id

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

Try NodePit Runner!