XLSX Simple Excel Format Apply (sheet select)

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.

Please note that the nature of this component is such that it needs to be initially executed with the path variable selected so that it can read the Excel sheet names. On first configuring, you will need to select the required path variable. Once selected, click Apply, and then re-execute the component. It will probably fail. Now you can configure it, and then apply/execute.

(If config options not showing, execute after selecting path variable and then re-configure)

@takbb Brian Bates 16 September 2023

Input ports

1. Type: Flow Variable
   Flow Variable
   Flow variable list containing at least one Path flow variable

Output ports

1. Type: Flow Variable
   Path flow variable out
   Flow variable list containing xlsx-sf-output-path variable which has path of newly created xlsx file