2

I have a workflow Knime, in the middle I must execute an external program to create an Excel file.

Exists some node that allows me to achieve this? I don't need to put any input or output, only execute the program and wait to generate the Excel file (I require to use this Excel for the next nodes).

MiBol
  • 1,985
  • 10
  • 37
  • 64

2 Answers2

3

There are (at least) two “External Tool” nodes which allow running executables on the command line:

In case that should not be enough, you can always go for a Java Snippet node. The java.lang.Runtime class should be your entry point.

qqilihq
  • 10,794
  • 7
  • 48
  • 89
  • 2
    If you use a Java Snippet, beware of the std out and std error streams- there is a good description at https://www.javaworld.com/article/2071275/core-java/when-runtime-exec---won-t.html – SteveR Aug 14 '18 at 10:23
1

It's could be used the External tool node. The node requires inputs and outputs... but, you can use a table creator node for input:

enter image description here

This create an empty table.

In the external tool node, you must include an Input file and Output file, depending on your request, this config could be meaningless but require to the Node works. enter image description here

In this case, the external app creates a text with the result of the execution, so, in the initial table (Table creator node), will be read the file and get the information into Knime.

MiBol
  • 1,985
  • 10
  • 37
  • 64