XLS Formatter (apply)

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 .

Input ports

1. Type: XLS Formatter
   XLS Formatter
   The XLS Formatter input port holding the collected formatting instructions for your xlsx file.

Source File System Connection (Dynamic Inport)

The source file system connection.

1. Type: File System

Destination File System Connection (Dynamic Inport)

The destination file system connection.

1. Type: File System