Icon

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

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 and set a style

Excel file header format with KNIME and OpenPyxl (with bundled Python in KNIME 4.7) - zip Excle file and send EmailFreeze the top row, autosize the columns and set a style locate and create/data/ folderwith absolute pathsdata1"my_data.xlsx"var_new_excel_file"my_data_new.xlsx"=> name of the new excel fileuse some styles on Excel file headerand export the result into a newfilev_max_rows=> Maximum Number of Rowsfor the headerNumber of Columnsvar_sheet_name" Sheet1" => name of the Sheetv_path_new_excel_filezip thenewly formatted Excel filev_path_*v_path_new_excel_zip_file=> you have to configurethis node !!!remove if in production Collect LocalMetadata Data Generator Excel Writer StringConfiguration Python Script Extract TableDimension IntegerConfiguration Table Columnto Variable StringConfiguration Java EditVariable (simple) CompressFiles/Folder String to Path(Variable) Java EditVariable (simple) Send Email Delete existing filesfor a clean start Merge Variables Merge Variables Merge Variables Excel file header format with KNIME and OpenPyxl (with bundled Python in KNIME 4.7) - zip Excle file and send EmailFreeze the top row, autosize the columns and set a style locate and create/data/ folderwith absolute pathsdata1"my_data.xlsx"var_new_excel_file"my_data_new.xlsx"=> name of the new excel fileuse some styles on Excel file headerand export the result into a newfilev_max_rows=> Maximum Number of Rowsfor the headerNumber of Columnsvar_sheet_name" Sheet1" => name of the Sheetv_path_new_excel_filezip thenewly formatted Excel filev_path_*v_path_new_excel_zip_file=> you have to configurethis node !!!remove if in productionCollect LocalMetadata Data Generator Excel Writer StringConfiguration Python Script Extract TableDimension IntegerConfiguration Table Columnto Variable StringConfiguration Java EditVariable (simple) CompressFiles/Folder String to Path(Variable) Java EditVariable (simple) Send Email Delete existing filesfor a clean start Merge Variables Merge Variables Merge Variables

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: 2022-10-31
On NodePit since: 2022-12-08
Last update: 2024-04-27
Created with KNIME version: v4.7.7
Tags: pythonopenpyxlknimestyleheader

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

Try NodePit Runner!