Instead of opening spreadsheets in the Excel Import Wizard, you can select File > Open to open the file. By default, JMP detects whether the first row contains labels and converts them to column headings. You can change this setting in the General preferences. The Excel Open Method preferences are in File > Preferences > General (Windows) and JMP > Preferences > General (Macintosh). From the Use Excel Labels for Headings list, select Always or Never.
|
1.
|
|
2.
|
Select the Excel Files file type, select the file, or enter the URL.
|
|
3.
|
To convert text in the first row to column headings, select Always next to Always enforce Excel Row 1 as labels.
|
|
4.
|
To select the worksheets that you want to open, click the Open button arrow, and then select Open Selected Worksheets. Select one or more worksheets and click OK.
|
1.
|
Select File > Open and select the file.
|
|
2.
|
(.xls only) To convert text in the first row to column headings, select Use Excel Labels as Headings.
|
|
3.
|
|
4.
|
Click Open.
|
If you chose to open specific worksheets, select those worksheets from the list, and then click OK. You can also click Select All if you change your mind and want to import all worksheets.
If you chose to open specific worksheets, select those worksheets from the list, and then click OK. You can also click Select All if you change your mind and want to import all worksheets.
If you selected an .xlsx file, a preview of the data appears in the Excel Wizard. See Preview and Import the Microsoft Excel Data for details.