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


Using JMP > JMP Preferences > Preferences for Third-Party Data
Publication date: 06/21/2023

Preferences for Third-Party Data

These preferences specify settings for third-party data, such as Microsoft Excel and SPSS files.

Figure 14.15 Third Party Data Preferences 

Third Party Data Preferences

Table 14.14 Preferences on the Third Party Data Page

Preference

Description

Excel Open Method

Select one of the options to determine how JMP imports Microsoft Excel worksheets.

Excel Wizard

Lets you preview a Microsoft Excel worksheet and modify the settings before importing the data. This is the default setting on Windows. On macOS, all .xlsx files open in the Excel Wizard.

Open All Sheets

Opens all worksheets in the workbook. On macOS, this preference is only for .xls files.

Select Individual Worksheets

Lets you select the worksheets that you want to open from a workbook. On macOS, this preference is only for .xls files. The option is also provided on macOS when you open an Excel (.xls) file.

On Windows, you can also select File > Open, select the workbook, click the Open button arrow, and select Open Selected Worksheets or Use Excel Wizard.

Use Excel Labels as Headings

Select this option to allow JMP to use Excel label names as column headings when importing Excel files. Available settings include:

Use best guess (default)

Always

Never

Image Format for PowerPoint

Select the default file format for images exported to Microsoft PowerPoint.

Windows does not support the native PDF graphics produced on macOS. macOS does not support the native EMF graphics produced on Windows. For cross-platform compatibility, specify the PNG or JPEG graphic format. Additional file formats are available through scripting. See db<<Save Presentation(<path>, <Template(path)>, <Insert("Begin"|"End"|n)|Replace("Begin"|"End"|n)|Append>, <Outline Titles(title location)>, <format>) in the JSL Syntax Reference.

Use SPSS Labels for column names during import

Select this option to allow JMP to use SPSS label names as column headings when importing SPSS files.

Use Triple-S Labels as Headings

Select this option to allow JMP to use Triple-S label names as column headings.

Want more information? Have questions? Get answers in the JMP User Community (community.jmp.com).