At the end of a workflow, I would like to launch Excel, windows script, batch file, bash script, or any other application. For my purposes, Knime’s work is complete and I want to allow a new app to run and carry on.
I have been able to do this using a python script but seems like overkill to install Anaconda just to do this. In this case I have gotten the name of an Excel file with full path to the Python script node from incoming connected and just opened it.
import os
output_table_1 = input_table_1.copy()
v1 = input_table_1[‘fqFileName’].iloc[0]
os.startfile(v1)
I am not trying to temporarily transfer control or results and get anything back. Just want to launch something.
Seems like there should be an easier way to do this in Knime.
I have. The issue I have with that is the ability to pass all the setting as variables. When I look at the variable tab it does not seem like I can pass all of the different custom paths required.
So, all I would like to do is launch an Excel workbook. (windows OS). Ideally, I would want to pass a fully qualified filename i.e. c:\temp\a.xlsx and just open that file. No further actions required.
I am not seeing all of the variables in the External Tool section on the Launch Settings tab.
and unchecking the Propagate stderr to Exception box.
I hadn’t ever tried the CmdwInput node before, but was able to get it to work in the same way by providing the command above as an input string with a Table Creator.
Very strange. I can open Excel by itself but not with file.
cmd /c “C:\Program Files\Microsoft Office\root\Office16\EXCEL.EXE File.xlsx”
or cmd /c “C:\Program Files\Microsoft Office\root\Office16\EXCEL.EXE” “file.xlsx”
not opens file.
Please advise.