Loading …
NodePit
  • Products
  • Nodes
  • Workflows
  • v5.5
    Select your KNIME version:v5.5v5.4v5.3v5.2v5.1v5.0v4.7v4.6v4.5v4.4v4.3v4.2v4.1v4.0v3.7v3.6
    v5.6Nightly
  • Log InSign Up
  1. HomeHome
  2. WorkflowsWorkflows
  3. KNIME ForumKNIME Forum
  4. KNIME Analytics PlatformKNIME Analytics Platform
  5. read-excel-97-2003-files-that-have-a-format-problem-with-pythonread-excel-97-2003-files-that-have-a-format-problem-with-python
  6. Excel 97-2003 Import - KNIME Forum (77371)Excel 97-2003 Import - KNIME Forum (77371)
Icon

Excel 97-2003 Import - KNIME Forum (77371)

Import a TXT file with .xls ending. Also import an Excel 97-2003 file that has been saved from LibreOffice or with Python package xlwt

- import with the Excel Reader
- import with Python, Pandas and xlrd
- import with R and readxl


You will need these Python packages

conda install -n py3_knime -c conda-forge xlrd
conda install -n py3_knime -c conda-forge xlwt

Nodes

  • String to Date&Time4 ×
  • Column Expressions2 ×
  • Python Script2 ×
  • Table Row to Variable2 ×
  • Table Writer2 ×
  • Component Input1 ×
  • Component Output1 ×
  • Conda Environment Propagation1 ×
  • Create File/Folder Variables1 ×
  • Create Folder1 ×
  • Excel Reader1 ×
  • Excel Writer1 ×
  • Extract Context Properties1 ×
  • File Reader1 ×
  • Java Edit Variable (simple)1 ×
  • Java Snippet (simple)1 ×
  • Merge Variables1 ×
  • R Snippet1 ×
  • Row Filter1 ×
  • String To Number (PMML)1 ×
  • String to Path1 ×
  • String to Path (Variable)1 ×
  • Table Creator1 ×
  • Variable to Table Row1 ×

Extensions

  • FeatureKNIME Base nodes
  • FeatureKNIME Column Expressions (legacy)
  • FeatureKNIME Conda Integration
  • FeatureKNIME Excel Support
  • FeatureKNIME Interactive R Statistics Integration
  • Show all 7 modules

Links

  • Read Excel 97-2003 files that have a format problem with python
    forum.knime.com/p/250337

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: m_lauber
Created at: 2024-02-21
On NodePit since: 2024-02-23
Last update: 2025-07-18
Created with KNIME version: v5.2.1
Tags: rrstudioexcelexcel97importread_excelreadxlxlwtxlrd

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!
IntroNodesExtensionsLinks
Contact

Do you have feedback, questions, comments about NodePit, want to support this platform, or want your own nodes or workflows listed here as well? Do you think, the search results could be improved or something is missing? Then please get in touch! Alternatively, you can send us an email to mail@nodepit.com.

Please note that this is only about NodePit. We do not provide general support for KNIME — please use the KNIME forums instead.

NodePit is the world’s first and most comprehensive search engine that allows you to easily search, find and install KNIME nodes and workflows. Explore the KNIME community’s variety.

Impressum / Imprint
Datenschutzerklärung / Privacy Policy

Thank you to the following supporters — without them, NodePit would not be possible!

Legal info: The KNIME® trademark is registered in the United States and Germany by the KNIME GmbH. NodePit is not affiliated with KNIME®.