Hub
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
  • KNIME Hub
  • Nodes
  • Write To Excel Template
NodeNode / Other

Write To Excel Template

Community Nodes AF Utilities ExcelUtil
Drag & drop
Like
Copy short link

This node writes the input data table into an existing Excel file without changing its formatting.
Alternatively a new file will be created based on the template file formats and data. The input data will be written to the second row without header by default (can be changed in the Advanced Options) Already populated cells in the input file will be overwritten.
The node supports three formats chosen by file extension: XLS,XLSX,XLSM

Node details

Input ports
  1. Type: Table
    Input table
    Table that contains columns to write to Excel. Most column types are supported. (Strings, Integer, Double, Timestamps, PNG Pictures and file paths. If you want to create formulas, then start a String column with '=' followed by the formula. (the formula has to use the english function names)

Extension

The Write To Excel Template node is part of this extension:

  1. Go to item

Related workflows & nodes

  1. Go to item
    try to find a workaround to re-calculate Excel formulas on sheets other than the one being imported
    Excel Openpyxl Python
    +2
    try to find a workaround to re-calculate Excel formulas on sheets other than the one bein…
    mlauber71 > Forum > 2021 > kn_forum_38380_excel_re_evaluate_formulas

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