Hub
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
  • KNIME Hub
  • Nodes
  • XLS Formatter (apply)
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:

  1. Go to item

Related workflows & nodes

  1. Go to item
    left align columns A to F
    kowisoft > Public > left align columns A to F
  2. Go to item
    Excel Formatting to Double
    kathrin > Forum Questions > Excel Formatting to Double
  3. Go to item
    different formats - align columns B, C and D
    kowisoft > Public > different formats - align columns B, C and D
  4. Go to item
    Coloured_Column
    mythxahir > Public > Coloured_Column
  5. Go to item
    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. Go to item
    99 - final workflow
    kowisoft > Public > Continental XLS Formatter Tutorial > 99 - final workflow
  7. Go to item
    08 - apply formats
    kowisoft > Public > Continental XLS Formatter Tutorial > 08 - apply formats
  8. Go to item
    Alternating Colors for Different Values - Conti Nodes
    kathrin > Forum Questions > Alternating Colors for Different Values - Conti Nodes
  9. Go to item
    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. Go to item
    Apply formatting to different sheets created in a loop
    kathrin > Forum Questions > Apply formatting to different sheets created in a loop

No known nodes available

KNIME
Open for Innovation

KNIME AG
Hardturmstrasse 66
8005 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • E-Learning course
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • KNIME Open Source Story
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more on KNIME Server
© 2022 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Credits