XLS Control Format Template 0

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

This component works as a "template". Save it locally and detach from the original. Then you can modify the settings, or add additional formatting options internally and save as a template component locally with a different name.

Heading: Black back, yellow foreground
Doubles as #0.00
Dates as dd-mm-yyyy
Even numbered rows to cream

@takbb Brian Bates Updated 4 October 2022

Input ports

1. Type: Table
   XLS Formatter Control Table
   XLS Control Table pass through. By chain linking both Control Table and Formatting nodes, the worksheet remains tidier
2. Type: XLS Formatter
   XLS Formatting Input
   Formatting input from another XLS Formatting Node or XLS Auto Tag Generator component

Output ports

1. Type: XLS Formatter
   XLS Formatter Control Table Output
   Pass this on to another XLS Formatting component