Hub
Pricing About
WorkflowWorkflow

KNIME and Python's openpyxl to extract named tables (ranges) from Excel file (using the bundled KNIME Python version)

ExcelOpenpyxlImportPythonExcel
+3
mlauber71 profile image
Draft Latest edits on 
Nov 23, 2018 7:07 PM
Drag & drop
Like
Download workflow
Workflow preview
KNIME and Python's openpyxl to extract named tables (ranges) from Excel file (using the bundled KNIME Python version) https://forum.knime.com/t/read-from-excel-table/38190/8?u=mlauber71 The Excel File "Tables.xlsx" contains 4 named Table ranges which will be imported into KNIME. First in one step. The second Python node would give back the cell ranges and use that information to extract the tables

External resources

  • Manipulate Excel files in KNIME with Python openPyXL
  • openpyxl - A Python library to read/write Excel 2010 xlsx/xlsm files
  • (stackoverflow) how to extract different tables in excel sheet using python
  • forum entry
  • KNIME and Python's openpyxl to define and name a Data area in Excel
  • KNIME and Python - Combine the best of visual programming with scripting
  • openpyxl - A Python library to read/write Excel 2010 xlsx/xlsm files
  • HUB: KNIME and Python's openpyxl to extract named tables (ranges) from Excel file (using the bundled KNIME Python version)
  • BLOG: How to Set Up Your Python Extensions
Loading deploymentsLoading ad hoc jobs

Used extensions & nodes

Created with KNIME Analytics Platform version 4.7.1
  • Go to item
    KNIME Base nodesTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.7.1

    knime
  • Go to item
    KNIME Excel SupportTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.7.0

    knime
  • Go to item
    KNIME ExpressionsTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.7.0

    knime
  • Go to item
    KNIME JavasnippetTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.7.0

    knime
  • Go to item
    KNIME Python IntegrationTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.7.1

    knime

Legal

By using or downloading the workflow, you agree to our terms and conditions.

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