cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar
Dennisbur
Level IV

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

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

2 REPLIES 2
mmarchandTSI
Level V

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

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().

jthi
Super User

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

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

-Jarmo