JMP 12 Online Documentation (English)
Discovering JMP
Using JMP
Basic Analysis
Essential Graphing
Profilers
Design of Experiments Guide
Fitting Linear Models
Specialized Models
Multivariate Methods
Quality and Process Methods
Reliability and Survival Methods
Consumer Research
Scripting Guide
JSL Syntax Reference
JMP iPad Help
JMP Interactive HTML
Capabilities Index
JMP 13.2 Online Documentation
Scripting Guide
•
Extending JMP
• Working with Excel
Previous
•
Next
Working with Excel
You can script the Profiler interface to 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 Excel Profiler object, you can send the following messages to run the JMP prediction profiler using the Excel model. For example:
excel_obj <<Prediction Profiler( 1 );