Hub
NodeNode / Sink

XLS Formatter (apply)

Community Nodes Continental XLS Formatter
Drag & drop
Like
Copy short link

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 .

Node details

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

Extension

The XLS Formatter (apply) node is part of this extension:

Related workflows & nodes

  1. left align columns A to F
    kowisoft > Public > left align columns A to F
  2. Excel Formatting to Double
    kathrin > Forum Questions > Excel Formatting to Double
  3. different formats - align columns B, C and D
    kowisoft > Public > different formats - align columns B, C and D
  4. Coloured_Column
    mythxahir > Public > Coloured_Column
  5. Styling Excel Tables - Solution
    Excel Customization XSL
    +2
    Solution to exercise 12 for the KNIME Analytics Platform for Data Wranglers course - Writ…
    knime > Education > Courses > L2-DW KNIME Analytics Platform for Data Wranglers - Advanced > Solutions > 12_Styling_Excel_Tables_Solution
  6. 99 - final workflow
    kowisoft > Public > Continental XLS Formatter Tutorial > 99 - final workflow
  7. 08 - apply formats
    kowisoft > Public > Continental XLS Formatter Tutorial > 08 - apply formats
  8. Alternating Colors for Different Values - Conti Nodes
    kathrin > Forum Questions > Alternating Colors for Different Values - Conti Nodes
  9. create an Excel file with a complex header with the help of Continental Excel nodes
    Excel Header Combine
    +2
    create an Excel file with a complex header with the help of Continental Excel nodes
    mlauber71 > Forum > 2022 > kn_forum_42140_excel_continental_nodes_complex_header
  10. Apply formatting to different sheets created in a loop
    kathrin > Forum Questions > Apply formatting to different sheets created in a loop