topic Save data as Excel file and immediately open it on the computer in Discussions

Save data as Excel file and immediately open it on the computer

Dennisbur — Thu, 15 Feb 2024 15:06:14 GMT

Hello

I would like to save data in an Excel file and open it

I have written the command at the end of the script

I see JMP saved the data as well, but don't open the file in Excel

what I have missed in JSL?

dt_excel = dt_p << Save( "C:\Users\dburmist\Downloads\Bucket.xlsx" );
dt_excel = dt_p << open( "C:\Users\dburmist\Downloads\Bucket.xlsx" );

Re: Save data as Excel file and immediately open it on the computer

mmarchandTSI — Thu, 15 Feb 2024 15:22:03 GMT

The Open() function is not a message to send to a data table. <<Open() as a message is used to show or hide values in a Matrix Box or specify an image to add to a PictSeg. When you tell JMP to Open() an Excel file, it imports it into JMP; it doesn't open it in Excel. If that's what you want, you'll probably need to Run Program().

Re: Save data as Excel file and immediately open it on the computer

jthi — Thu, 15 Feb 2024 15:23:17 GMT

You can use Web() to open the excel file

Names Default To Here(1);

dt = Open("$SAMPLE_DATA/Big Class.jmp");

savepath = Convert File Path("$TEMP/Big Class.xlsx", windows);
dt << Save(savepath);

Web(savepath);

Other option would be to use Run Program