Hub
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:

Related workflows & nodes

  1. 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. 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. 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. 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. 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. 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. 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. Excel Formatter - Excelの装飾
    Japanese 日本語 Makkynm
    +13
    Excel FormatterのNode紹介用Workflowです。 InputファイルはInputフォルダからダウンロードしてください。 これらのNodeを使うには拡張機能のイ…
    makkynm > Public > Intermediate > I211_Excel_Formatter
  9. 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. 02_Pretty_Table
    This example workflow is licensed under the MIT License. See LICENSE.txt in the workflow …
    bdu > Public > 02_Pretty_Table