Scripting Guide > Extending JMP > Work with Microsoft Excel
发布日期: 09/18/2023

Work with Microsoft Excel

You can script the JMP 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 );
需要更多信息?有问题?从 JMP 用户社区得到解答 (community.jmp.com).