Hub
Pricing About
WorkflowWorkflow

Replace an Excel Sheet in a XLSM File - KNIME Forum (75867)

XlsmMacroExcelLoadWrite
+1
mlauber71 profile image
Draft Latest edits on 
Dec 8, 2023 8:28 AM
Drag & drop
Like
Download workflow
Workflow preview
Use the Excel Writer to append a sheet to an Excel File with a Macro in it (.XLSM)

External resources

  • Forum Entry (75867)
  • HUB: use R's openxlsx to add a worksheet to an existing Excel file with a macro .xlsm
  • MEDIUM: KNIME and R — installation across operating systems — some remarks
  • R - openxlsx: Read, Write and Edit xlsx Files
  • Import EXCEL - a meta workflow trying to answer questions about importing data from Excel files
  • original discussion
Loading deploymentsLoading ad hoc jobs

Used extensions & nodes

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

    KNIME AG, Zurich, Switzerland

    Version 5.2.0

    knime_admin
  • Go to item
    KNIME Excel SupportTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 5.2.0

    knime_admin

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
© 2026 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Data Processing Agreement
  • Credits