cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Discussions

Solve problems, and share tips and tricks with other JMP users.
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

Recommended Articles