XLSX Simple Excel Format Apply (branch safe)

Provides a simplified interface to basic formatting using the Continental XLS Formatting community extension.

Simply attach this node after an Excel Writer and pass it the path variable identifying the XLSX file to which basic formatting is to be applied.

(This path variable can be most easily created within the Excel Writer node itself, by clicking the "V" button next to the file path, and supply a variable name next to "Create")

Basic formatting of header row, data text colour and font size plus numeric and date format is possible without having to learn how to manipulate the Continental nodes themselves.


@takbb Brian Bates 16 September 2023
v1.1 2023-09-27

Options

Freeze Panes

Freeze Top Row and Left column?

Open File after execution

Choose whether to open the file in Excel after formatting has been applied

Choose source path variable

Choose the path variable that contains the file name that you wish to edit

Freeze pane at column

Specify the column at which it should freeze the pane. %%00010%%00010e.g. To freeze just column 1, set it to 1

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

Suffix to append to file name for formatted xlsx

Enter a suffix that will be appended to the existing xlsx file name to create the formatted version of the file. (The original file will remain unchanged)

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.%%00010%%00010To make the column BOLD, it will use the reverse of the background/foreground colours chosen for the data rows (ignroing "banding")

Nodes

• String Configuration36 ×
• String Manipulation (Variable)33 ×
• Variable to Table Row17 ×
• Component Input16 ×
• Component Output16 ×
• Show all 78 nodes

Extensions

• FeatureContinental Nodes for KNIME
• FeatureKNIME Base nodes
• FeatureKNIME Basic File System Connectors
• FeatureKNIME Data Generation
• FeatureKNIME Ensemble Learning Wrappers
• Show all 9 modules

Links

• No links available