Icon

Excel Formatting demo workflow from hub

Excel Formatting

If you would like to format your Excel File, you can use the Community Extension: Continental Nodes for KNIME
With those nodes, you can create a control table. The control table simply serves as a template table containing certain tags for the cells, which are going to be formatted. In this example, we do conditional formatting based on certain values in the cells, we change the font and we change the column width. The defined formats from the control table are only applied to the actual data table at the end using the XLS Formatter (apply) node. This provides the possibility to apply the defined formats to several different Excel files.

Required Extensions:
- Continental Nodes for KNIME
- KNIME Base Chemistry Types & Nodes


Excel FormattingIf you would like to format your Excel File, you can use the Community Extension: Continental Nodes for KNIMEWith those nodes, you can create a control table. The control table simply serves as a template table containing certain tags for the cells, which are going to beformatted. In this example, we do conditional formatting based on certain values in the cells, we change the font and we change the column width. The defined formatsfrom the control table are only applied to the actual data table at the end using the XLS Formatter (apply) node. This provides the possibility to apply the defined formatsto several different Excel files.Required Extensions:- Continental Nodes for KNIME create control table and define formattings increase header fontcolor byvaluesgeneratecontrol tableinsert tag "header"use existing tableas starting point for control tableincrease column width XLS Font Formatter XLS ConditionalFormatter XLS ControlTable Generator XLS Formatter(apply) XLS Control Tablefrom Cell Range Column Expressions XLS Row andColumn Sizer Path to String(Variable) Excel Reader Excel Writer Excel FormattingIf you would like to format your Excel File, you can use the Community Extension: Continental Nodes for KNIMEWith those nodes, you can create a control table. The control table simply serves as a template table containing certain tags for the cells, which are going to beformatted. In this example, we do conditional formatting based on certain values in the cells, we change the font and we change the column width. The defined formatsfrom the control table are only applied to the actual data table at the end using the XLS Formatter (apply) node. This provides the possibility to apply the defined formatsto several different Excel files.Required Extensions:- Continental Nodes for KNIME create control table and define formattings increase header fontcolor byvaluesgeneratecontrol tableinsert tag "header"use existing tableas starting point for control tableincrease column width XLS Font Formatter XLS ConditionalFormatter XLS ControlTable Generator XLS Formatter(apply) XLS Control Tablefrom Cell Range Column Expressions XLS Row andColumn Sizer Path to String(Variable) Excel Reader Excel Writer

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: janinamothes
Created at: 2021-03-15
On NodePit since: 2022-02-06
Last update: 2024-04-27
Created with KNIME version: v4.3.2
Tags: Life SciencesExcelFormatMolecule

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

Try NodePit Runner!