Icon

Write Excel table (format)

Write Excel table (format)
this workflow saves the output table as an Excel file and converts that data in Excel to the table format (withfiltering functionality) using the python lib "Openpyxl".Python has to run in Version 3.x and Openpyxl has to be installed. Other libs used: string, os.Please configure the definition of the file(path) and the name of the Excel sheet in the red-boxed area. sample dataget num ofrows, columnswriting excel filepath to filesheet nameopenpyxlconverting totable format Table Creator Extract TableDimension Table Columnto Variable Excel Writer String Manipulation(Variable) String Manipulation(Variable) String to Path(Variable) Python Script this workflow saves the output table as an Excel file and converts that data in Excel to the table format (withfiltering functionality) using the python lib "Openpyxl".Python has to run in Version 3.x and Openpyxl has to be installed. Other libs used: string, os.Please configure the definition of the file(path) and the name of the Excel sheet in the red-boxed area. sample dataget num ofrows, columnswriting excel filepath to filesheet nameopenpyxlconverting totable formatTable Creator Extract TableDimension Table Columnto Variable Excel Writer String Manipulation(Variable) String Manipulation(Variable) String to Path(Variable) Python Script

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: 2018-11-23
On NodePit since: 2021-08-31
Last update: 2024-04-28
Created with KNIME version: v4.4.0
Tags: #python#openpyxl#excel

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

Try NodePit Runner!