Icon

Format Excel with Python in KNIME

This very simple workflow shows how to write an excel file and apply basic formatting of excel worksheets using the Python node and openpyxl
This very simple workflow shows how to save and apply basic formatting of excel worksheets using OpenPyXl Format Excel files using OpenPyXlGet CSV DataSave as Excel FileSetup VariableUPDATE FOR YOUR FILE SYSTEMConvert File Path to String for use in Python Python Script CSV Reader Excel Writer Create File/FolderVariables Path to String(Variable) This very simple workflow shows how to save and apply basic formatting of excel worksheets using OpenPyXl Format Excel files using OpenPyXlGet CSV DataSave as Excel FileSetup VariableUPDATE FOR YOUR FILE SYSTEMConvert File Path to String for use in PythonPython Script CSV Reader Excel Writer Create File/FolderVariables Path to String(Variable)

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: walke
Created at: 2024-02-12
On NodePit since: 2024-02-14
Last update: 2024-05-02
Created with KNIME version: v5.2.1
Tags: PythonExcelopenpyxl

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

Try NodePit Runner!