User Community
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Don’t miss your chance to experience Discovery Summit Europe at our best available rate! Early bird registration through 31 Oct.
  • Image to Table JMP extension imports single or batch images as data tables. Useful to extract curves from pictures or convert image data to curve data to use in analyses like Functional Data Explorer. Download and install the extension.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
hgarbig
hgarbig
Level I

Import excel in JMP18

Jul 24, 2024 01:58 PM (1957 views)

Previously using JMP17, any import format of a column in excel would carry over the same format into JMP, but JMP18 is changing from numeric to character if there are any blank cells in that column.  Is there a setting in preferences I need to change?

0 Kudos
1 REPLY 1
jthi
Super User jthi
Super User

Re: Import excel in JMP18

Created: Jul 24, 2024 02:09 PM  |  Last Modified: Jul 24, 2024 11:14 AM (1949 views)  |  Posted in reply to message from hgarbig 07-24-2024

I don't think there are such settings. You might be able to change the format in the excel wizard

jthi_0-1721844432693.png

or better option in my opinion, change the data and modeling type AFTER you have imported the data into JMP table.

 

Edit: You can get information about the excel import from https://www.jmp.com/support/help/en/18.0/#page/jmp/preview-and-import-microsoft-excel-data.shtml# and there were changes in JMP18 https://community.jmp.com/t5/JMP-Knowledge-Base/Changes-to-the-import-of-Microsoft-Excel-files-in-JM... 

-Jarmo

Recommended Articles