724408_en-US

liliconcom

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

Automation and ScriptingWindowsRe: 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

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