Public
This directory contains 394 workflows.
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
kn_example_python_excel_import_simple_file_openpyxl
Import Excel File with OpenPyxl (simple)
kn_example_python_excel_meta_information_files
Extract meta information from Excel file (with the help of Python) https://forum.knime.com/t/extract-date-modified-from-an-excel-file/46332/3?u=mlauber71
kn_example_python_excel_password_protection
KNIME - use openpyxl to set password on Excel, read-protect a sheet, freeze a top row and add a filter (and hind and unhide your worksheet) There are […]
kn_example_python_excel_read_comments
use KNIME and Python OpenPyxl to read the the comments fro all cells in an Excel file and save them as table KNIME and Python — Setting up and managing […]
kn_example_python_excel_read_password_protected_file
use python library msoffcrypto to decrypt excel file and read it back into KNIME
kn_example_python_excel_remove_sheet
use Python package openpyxl to remove an existing worksheet from an Excel file