For the latest version of JMP Help, visit JMP.com/help.

Scripting Guide > Extending JMP > Work with Microsoft Excel
Publication date: 09/28/2021

Work with Microsoft Excel

You can script the Profiler interface to Microsoft Excel, although not the Transfer to JMP interface. Here is the basic syntax:

excel_obj = Excel Profiler(
	Workbook( "excel_workbook_path" ),
	Model( "name_of_model" )
);

The Model argument is optional. If you supply only the workbook, you are prompted to select the model. You do not need to specify the worksheet, because the model is found no matter where it is located.

Once you have an Microsoft Excel Profiler object, you can send the following messages to run the JMP prediction profiler using the Microsoft Excel model. For example:

excel_obj <<Prediction Profiler( 1 );
Want more information? Have questions? Get answers in the JMP User Community (community.jmp.com).