Excel Formatting

0 ×

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

Nodes

• XLS Control Table from Cell Range2 ×
• XLS Row and Column Sizer2 ×
• Column Expressions1 ×
• Excel Reader1 ×
• Excel Writer1 ×
• Show all 10 nodes

Extensions

• FeatureContinental Nodes for KNIME
• FeatureKNIME Column Expressions (Labs)
• FeatureKNIME Excel Support
• FeatureKNIME SVG Support

Links

• No links available