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