Hub
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
  • KNIME Hub
  • Nodes
  • XLS Border Formatter
NodeNode / Manipulator

XLS Border Formatter

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

The XLS Border Formatter node changes cell borders of a given range (not necessarily rectangular) specified by tags in a control table. You can select which borders of the matching cells shall be displayed in which style and optionally also change the border color accordingly.

This node defines a formatting instruction only. It needs to be written to an xlsx file via the XLS Formatter (apply) node subsequently.

Node details

Input ports
  1. Type: Table
    Control Table
    XLS Control Table holding tags that define which cells of the sheet to format.
  2. Type: XLS Formatter
    Optional XLS Formatter
    The XLS Formatter input port potentially holding previous formatting instructions that the instructions of this node shall be added to.
Output ports
  1. Type: XLS Formatter
    XLS Formatter
    The XLS Formatter output port holding the collected formatting instructions including the added formatting information from this node.

Extension

The XLS Border Formatter node is part of this extension:

  1. Go to item

Related workflows & nodes

  1. Go to item
    04_XLS_BorderFormatter
    This example workflow is licensed under the MIT License. See LICENSE.txt in the workflow …
    knime > Examples > 99_Community > 05_Continental_Nodes_for_KNIME > 02_XLS_Formatter > 01_Tutorials > 04_XLS_BorderFormatter
  2. 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…
    marten_kose > Public > L1-L2-DW KNIME Analytics Platform for Data Wranglers_advanced_4.0 > Solutions > 12_Styling_Excel_Tables_Solution
  3. 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
  4. 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…
    scottf > Public > L2-DW Version 4.3 > Solutions > 12_Styling_Excel_Tables_Solution
  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…
    ana_ved > L2-DW 3.3 > L2-DW KNIME Analytics Platform for Data Wranglers - Advanced 2 > Solutions > 12_Styling_Excel_Tables_Solution
  6. 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…
    tenalf > Public > L2-DW KNIME Analytics Platform for Data Wranglers - Advanced > Solutions > 12_Styling_Excel_Tables_Solution
  7. Go to item
    22_XLS_MultipleSheets
    This example workflow is licensed under the MIT License. See LICENSE.txt in the workflow …
    knime > Examples > 99_Community > 05_Continental_Nodes_for_KNIME > 02_XLS_Formatter > 01_Tutorials > 22_XLS_MultipleSheets
  8. Go to item
    Excel Formatter - Excelの装飾
    Japanese 日本語 Makkynm
    +13
    Excel FormatterのNode紹介用Workflowです。 InputファイルはInputフォルダからダウンロードしてください。 これらのNodeを使うには拡張機能のイ…
    makkynm > Public > Intermediate > I211_Excel_Formatter
  9. Go to item
    02_Pretty_Table
    This example workflow is licensed under the MIT License. See LICENSE.txt in the workflow …
    knime > Examples > 99_Community > 05_Continental_Nodes_for_KNIME > 02_XLS_Formatter > 02_Applications > 02_Pretty_Table
  10. Go to item
    02_Pretty_Table
    This example workflow is licensed under the MIT License. See LICENSE.txt in the workflow …
    bdu > Public > 02_Pretty_Table

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