Hub
Pricing About
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
  • KNIME Community Hub
  • Nodes
  • Excel Writer
NodeNode / Sink

Excel Writer

IO Write Streamable
Drag & drop
Like
Copy short link

This node writes the input data table into a spreadsheet of an Excel file, which can then be read with other applications such as Microsoft Excel. The node can create completely new files or append data to an existing Excel file. When appending, the input data can be appended as a new spreadsheet or after the last row of an existing spreadsheet. By adding multiple data table input ports, the data can be written/appended to multiple spreadsheets within the same file.

The node supports two formats chosen by file extension:

  • .xls format: This is the file format which was used by default up until Excel 2003. The maximum number of columns and rows held by a spreadsheet of this format is 256 and 65536 respectively.
  • .xlsx format: The Office Open XML format is the file format used by default from Excel 2007 onwards. The maximum number of columns and rows held by a spreadsheet of this format is 16384 and 1048576 respectively.

If the data does not fit into a single sheet, it will be split into multiple chunks that are written to newly chosen sheet names sequentially. The new sheet names are derived from the originally selected sheet name by appending " (i)" to it, where i=1,...,n.
When appending to a file, a sheet may already exist. In this case the node will (according to its settings) either replace the sheet, fail or append rows after the last row in that sheet. This can be used to append data to an Excel file without having to create a new sheet name once the original sheet is full by just selecting the original sheet name. The data will be appendend to the last sheet in the name sequence. The original sheet name does not have to be changed.

This node does not support writing files in the '.xlsm' format, yet appending is supported.

This node can access a variety of different file systems. More information about file handling in KNIME can be found in the official File Handling Guide.

Node details

Input ports
  1. Type: Table
    Input table
    The data table to write.
File System Connection (Dynamic Inport)
The file system connection.
  1. Type: File System
Sheet Input Ports (Dynamic Inport)
Additional data table to write.
  1. Type: Table

Extension

The Excel Writer node is part of this extension:

  1. Go to item

Related workflows & nodes

  1. Go to item
    Excel Writer Example
    data_coach > KNIME Foundations > 2 - Reading and Writing Data > 5 - Excel Writer > Excel Writer Example
    data_coach
  2. Go to item
    SAP ECC Inventory Management - Material Doc List
    SAP DWV Analytics
    SAP T-Code MB51 (Display Material Document List) provides a list of Material Documents ba…
    knime_sap > Public > SAP ECC Inventory Management - Material Doc List (T-Code MB51)
    knime_sap
  3. Go to item
    Reading and Writing Solution
    data_coach > KNIME Foundations > 2 - Reading and Writing Data > 6 - Reading and Writing Data Practice > Reading and Writing Solution
    data_coach
  4. Go to item
    SAP Sales - List of Contracts (T-Code VA45N)
    SAP DVW Analytics
    This workflow from DVW Analytics demonstrates how to extract a list of Contracts directly…
    knime_sap > Public > SAP Sales - List of Contracts (T-Code VA45N)
    knime_sap
  5. Go to item
    SAP Sales - List of Billing Documents (T-Code VF05N)
    SAP DVW Analytics
    Workflow Description: SAP T-Code VF05N (List of Billing Documents ) provides a list of Sa…
    knime_sap > Public > SAP Sales - List of Billing Documents (T-Code VF05N)
    knime_sap
  6. Go to item
    SAP Purchasing - Purchasing Group Analysis (T-code MCE1)
    SAP DVW Analytics
    SAP Purchasing - Purchasing Group Analysis (T-code MCE1) Workflow Description: This workf…
    knime_sap > Public > SAP Purchasing - Purchasing Group Analysis (T-code MCE1)
    knime_sap
  7. Go to item
    SAP Purchasing - Material Group Analysis (T-code MCE5)
    SAP DVW Analytics
    Workflow Description: This workflow from DVW Analytics demonstrates how to extract data f…
    knime_sap > Public > SAP Purchasing - Material Group Analysis (T-code MCE5)
    knime_sap
  8. Go to item
    SAP Purchasing - Vendor Analysis (T-code MCE3)
    SAP DVW Analytics
    Workflow Description: This workflow from DVW Analytics demonstrates how to extract data f…
    knime_sap > Public > SAP Purchasing - Vendor Analysis (T-code MCE3)
    knime_sap
  9. Go to item
    SAP Sales - List of Scheduling Agreements (T-Code VA35N)
    SAP DVW Analytics
    This workflow from DVW Analytics demonstrates how to extract a list of Scheduling Agreeme…
    knime_sap > Public > SAP Sales - List of Scheduling Agreements (T-Code VA35N)
    knime_sap
  10. Go to item
    SAP Controlling - Cost Centers Actual Line Items (T-code KSB1)
    SAP DVW Analytics
    Workflow Description: This workflow from DVW Analytics demonstrates how to extract data f…
    knime_sap > Public > SAP Controlling - Cost Centers Actual Line Items (T-code KSB1)
    knime_sap

No known nodes available

KNIME
Open for Innovation

KNIME AG
Talacker 50
8001 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 Business Hub
© 2023 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Credits