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

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

Georg — Fri, 09 Jun 2023 22:08:44 GMT

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*/);

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

Mauro_Gerber — Thu, 18 Mar 2021 09:39:36 GMT

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

txnelson — Thu, 18 Mar 2021 09:42:57 GMT

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");

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

Georg — Sat, 20 Mar 2021 18:44:33 GMT

Thanks @Mauro_Gerber and @txnelson for the proposals. In my case "run program" did work after some correction of the path string (fileshare starting with // on windows 10), the proposal with "web" did not work, I tried several times, it looks elegant.

I'm not sure, why, couldn't find anything in the log ..., simply no Excel started (Win10, Office16).

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

SeriyGena — Mon, 19 Feb 2024 19:19:16 GMT

Hello, i have similar, but not the same case. I already have the source file in xlsx format, and it includes multiple tabs.

I would like to have script that opens it as read only or its copy (copy is the best option) in excel.

My version of Win10 and in Win11 the is no option to this:

excel located at C:\Program Files\Microsoft Office\root\Office16\EXCEL.EXE

But excel alarm appeared with the meaning, that it can't find the file

Names Default To Here( 1 );
path="my_excel_file_absulute_path";
RP = Run Program(
	Executable( "C:\Program Files\Microsoft Office\root\Office16\EXCEL.EXE"),
	Options( {"/r",path} ),
);