368898_en-US

liliconcom

Open Excel File in Excel (Windows standard application) by JSL

Dear all,

my JMP should host a toolbox with also Excel and other files,

so I need to open a file by another application from my Windows system (JMP Pro 15.1, Win10).

Most preferably I would use that standard application that is used by windows explorer, when opening a file.

 

The example below opens the xls in JMP, I would like to open it in Excel, does anyone know how to accomplish that?

Thanks in advance!

Names Default To Here( 1 );

cdt = Open( "$SAMPLE_DATA\Big Class.jmp" );
xls_path = Convert File Path( "$TEMP\Big Class.xls" );
cdt << save as( "$TEMP\Big Class.xls" );

// open file in Excel application, not in JMP, how to ?
open(xls_path, /*Excel Wizard*/);

ScriptingRe: Open Excel File in Excel (Windows standard application) by JSL

Be aware to avoid spaces in the file name, otherwise the argument must include "path" in the string (so double")

 

Names Default To Here( 1 );

cdt = Open( "$SAMPLE_DATA\Big Class.jmp" );
xls_path = Convert File Path( "$TEMP\Big_Class.xls" );
cdt << save as( "$TEMP\Big_Class.xls" );

RP = Run Program(
 Executable( "C:\Program Files (x86)\Microsoft Office\Office15\excel.exe"/*path to excel, you may search it in the registration entry of microsoft*/ ),
 Options( {"/r",SUBSTR(xls_path,2)} ),
);

 

 

Re: Open Excel File in Excel (Windows standard application) by JSL

Using the Web() function is a quick and easy way to open an external file in it's assigned application

Names Default To Here( 1 );

cdt = Open( "$SAMPLE_DATA\Big Class.jmp" );
xls_path = Convert File Path( "$TEMP\Big Class.xls" );
cdt << save as( "$TEMP\Big Class.xls" );

web("$TEMP\Big Class.xls");