Hub
Pricing About
WorkflowWorkflow

Excel - Python - Identify Pivot Tables - KNIME Forum (80353)

ExcelPivotPythonXlwings
mlauber71 profile image
Draft Latest edits on 
Jul 9, 2024 12:27 PM
Drag & drop
Like
Download workflow
Workflow preview

Excel - try to identify which Excel sheets do contain Pivot tables with Python

The Python code will open Excel in the background using "xlwings" and check if there is an Excel file there

External resources

  • Medium: KNIME and Python — Setting up and managing Conda environments
  • KNIME Forum (80353)
  • xlwings - Make Excel fly with Python!
  • Get the Excel Pivot sample file here
Loading deploymentsLoading ad hoc jobs

Used extensions & nodes

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

    KNIME AG, Zurich, Switzerland

    Version 5.3.0

    knime
  • Go to item
    KNIME Basic File System ConnectorsTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 5.3.0

    knime
  • Go to item
    KNIME Conda IntegrationTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 5.3.0

    knime
  • Go to item
    KNIME Python IntegrationTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 5.3.0

    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