Public
This directory contains 400 workflows.
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
kn_example_python_excel_sheet_index
use KNIME and Python OpenPyxl to read the index numbers of every sheet in an Excel file. Then use the index numbers to import the files back ("did someone […]
kn_example_python_excel_sheet_move_to_position
use KNIME and Python OpenPyxl to read the index numbers of every sheet in an Excel file - then move a sheet from one index position to a new one
kn_example_python_excel_table_object_filter
KNIME and Python's openpyxl to define and name a Data area in Excel (using the bundled Python […]
kn_example_python_excel_table_object_read
KNIME and Python's openpyxl to extract named tables (ranges) from Excel file (using the bundled KNIME Python […]