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
- Math Formula (Multi Column)3 ×
- Column Expressions2 ×
- String to Path (Variable)2 ×
- CSV Reader1 ×
- Column Filter1 ×
- Column Renamer1 ×
- Counter Generation1 ×
- Create Folder1 ×
- Date&Time Part Extractor1 ×
- Excel Writer1 ×
- Extract Context Properties1 ×
- Java Snippet (simple)1 ×
- Path to String (Variable)1 ×
- Python Script1 ×
- Row Filter (Labs)1 ×
- RowID1 ×
- String Manipulation (Multi Column)1 ×
- String to Path1 ×
- Table Row to Variable1 ×
- Test Data Generator1 ×
- URL to File Path (Variable)1 ×
- Variable to Table Row1 ×
Extensions
- FeatureKNIME Base nodes
- FeatureKNIME Basic File System Connectors
- FeatureKNIME Column Expressions (Labs)
- FeatureKNIME Data Generation
- FeatureKNIME Excel Support
- Show all 9 modules
Links
- No links available