Hub
Pricing About
NodeNode / Sink

XLS Writer (deprecated)

IOWrite

This node has been deprecated and its use is not recommended. Please search for updated nodes instead.

Like

This node writes the input data table into a spreadsheet of a workbook. The files can be read then with other applications like Microsoft Excel, for example.

The node supports two formats, which one is used is derived from the file ending.

  • If the file name ends with 'xls' (e.g. filename.xls ) it will use the old Excel file format, which was used as default up until Excel 2003. The maximum number of columns held by a spreadsheet of this format is 256 (all additional columns in the data table are truncated). If the input data table has more than 65536 rows it is split into multiple spreadsheets (all stored in the created workbook).
  • If the file name ends with 'xlsx' (e.g. filename.xlsx ) it will use the Office Open XML format, which is the default format starting with Excel 2007.

Note that if the destination location is a remote URL not all options are available because in general it's not possible to determine whether the remote location exists. In this case it will always be overwritten.

Node details

Input ports
  1. Type: Table
    Input table
    The data table to write out.

Extension

The XLS Writer (deprecated) node is part of this extension:

  1. Go to item

Related workflows & nodes

  1. Go to item
  2. Go to item
  3. Go to item

KNIME
Open for Innovation

KNIME AG
Talacker 50
8001 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • Courses + Certification
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more about KNIME Business Hub
© 2025 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Data Processing Agreement
  • Credits