Icon

Excel - Manipulate File Properties using Python and OpenPyxl

<p>This Python script extracts and compares the metadata properties of an Excel file before and after modification, saves the comparison results as a CSV file, and stores the file path as a KNIME flow variable for further use in a KNIME workflow.</p>

URL: Excel Import Blocks https://forum.knime.com/t/move-head-rows-to-a-column/45094/2?u=mlauber71
URL: KNIME Blog: How to Set Up Your Python Extensions https://www.knime.com/blog/how-to-setup-the-python-extension
URL: Forum Entry (81726) https://forum.knime.com/t/excel-writer-and-metadata-and-powerbi/81726/8?u=mlauber71
URL: Stackoverflow: How to edit core properties of .xlsx file with Python? https://stackoverflow.com/a/52120837
URL: Blog: How to Set Up Your Python Extensions https://www.knime.com/blog/how-to-setup-the-python-extension

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: m_lauber
Created at: 2024-05-16
On NodePit since: 2024-08-13
Last update: 2024-09-16
Created with KNIME version: v5.3.1
Tags: ExcelOpenPyxlTablepropertypropertiesPythonworkbook

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

Try NodePit Runner!