XLS Simple Format Controller

Use this in conjunction with the XLS Control Table Auto Tag Generator component.

This component builds tags based on basic configuration options that can be applied using the Continental XLS Format Apply node.

@takbb Brian Bates 16 October 2023

Options

Freeze Panes
Freeze Top Row and Left column?
Heading font size
Enter the Font size for heading in pt (default 14pt)
Data font size
Enter the Font size for row date in pt (default 14pt)
Heading Text
Specify the colour of the heading text
Heading Background
Specify the colour of the heading background
Data Row Text
Specify the colour of the data row text
Data Background
Specify the colour of the data rows background
Data Alternate Banding
Use the data background colour on alternate lines to produce a banding effect
Footer Row Format
Choose additional format options for footer row
Name of Excel Sheet
Enter the name of the sheet in Excel to format
Number format (for Doubles / non-integer)
Enter the required number format for Doubles, or non-integer values
Date format
Enter the required format for dates
Integer format
Enter the required number format for Integer values
Apply footer special formatting to the following sheets: (comma delimited list)
Specify a list of sheets to which any specified footer (last row) formatting should be applied. This is a comma delimited list. You may use * to apply to all sheets.
Columns to be highlighted (Comma delimited list. Column may optionally be prefixed by sheetname e.g. sheet1.mycolumn)
Specify a list of columns to which highlighting is to be applied. A comma-separated list can be supplied.%%00010%%00010Column names are the exact heading names of columns, but may include wildcards. If the update is to apply only to that column on a specific sheet, then prefix with sheet name and period.%%00010%%00010e.g the following list:%%00010%%00010Sales, Amount*,summary.Total%%00010%%00010%%00010would appy highlighting to the column Sales and any column beginning Amount on any sheet, and additionally the Total column on the summary sheet.

Input Ports

Icon
XLS Control Table pass through. By chain linking both Control Table and Formatting nodes, the worksheet remains tidier
Icon
Formatting input from another XLS Formatting Node or XLS Auto Tag Generator component

Output Ports

Icon
Pass this on to another XLS Formatting component

Nodes

Extensions

Links

Download

To use this component in KNIME, download it from the below URL and open it in KNIME:

Download Component
On NodePit since: 2023-09-16
Last update: 2024-04-27
Created with KNIME version: v4.7.8

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

Try NodePit Runner!