Scripting Guide > Extending JMP > Work with Microsoft Excel
Publication date: 08/13/2020

Work with Microsoft Excel

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

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