The XLS Formatter (apply) node applies the chained commands from XLS Formatter nodes to an unformatted xlsx file.
All previous XLS Formatter nodes do not modify any xlsx files yet but prepare the formatting steps to be taken here. The input file may not contain any formatting yet (except very few styles that are tolerated due to date/time values handling).
This node supports the path flow variable to specify the source and destination location. To convert the created path column to a string column which is required by some nodes that have not been migrated yet you can use the Path to String node. For further information about file handling in general see the File Handling Guide .