Public
This directory contains 400 workflows.
kn_example_python_excel_enter_formula
use python package openpyxl to add formulas to excel files
kn_example_python_excel_enter_formula_openpyxl
use python package openpyxl to add formulas to excel files
kn_example_python_excel_export_simple_file_openpyxl
Export Excel File with OpenPyxl (simple) from KNIME - also add some formats
kn_example_python_excel_format_copy
KNIME and OpenPyxl - copy formats from one sheet to another
kn_example_python_excel_format_extract
extract the formats of the first data row of an Excel file with KNIME and […]
kn_example_python_excel_format_header
Excel file header format with KNIME and OpenPyxl Freeze the top row, autosize the columns and set a style
kn_example_python_excel_format_zip_send_mail
Excel file header format with KNIME and OpenPyxl (with bundled Python in KNIME 4.7) - zip Excle file and send Email Freeze the top row, autosize the columns […]
kn_example_python_excel_image_extract
Extract images from an Excel file with the help of Python / OpenPyxl there is a Jupyter notebook to experiment with under […]
kn_example_python_excel_import_export_openpyxl
use Python Pandas and Openpyxl to import and export Excel (sheets) and Export them back - also append to an existing Excel file
kn_example_python_excel_import_knime
KNIME - use Pandas and OpenPyxl to import a protected and formatted excel sheet - where import is otherwise slow