Hub
WorkflowWorkflow

use R's openxlsx to add a worksheet to an existing Excel file with a macro .xlsm

Openxlsx Xlsm Macro Excel Load
+3
mlauber71 profile image

Last edited: 

Drag & drop
Like
Download workflow
Copy short link
Workflow preview
it is possible to use R’s openxlsx to add sheets from within KNIME to an existing Excel file which contains Macros.. With newer Excel Writers this can be done without R.

Used extensions & nodes

Created with KNIME Analytics Platform version 4.4.2
  • KNIME Base nodes Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.4.2

    knime
  • KNIME Basic File System Connectors Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.4.2

    knime
  • KNIME Excel Support Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.4.2

    knime
  • KNIME Interactive R Statistics Integration Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.4.2

    knime
  • KNIME Javasnippet Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.4.2

    knime
Loading deployments
Loading ad hoc executions
Discussion