XLS Control Format Template 4

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.

sets headings to grey background
set columns to auto width
freeze header row, and
auto filter

@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