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: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar
ClassMandrill86
ClassMandrill86
Level II

Jmp not recognizing the column headers from excel

Created: Mar 20, 2023 03:33 PM  |  Last Modified: Jun 8, 2023 9:27 AM (3520 views)

I am trying to open an excel file from JMP to start analysis. This excel file has the column headers on row 1, but JMP is not able to detect the column names even after selecting the check mark on the import option and additionally, JMP only shows columns from 6 and doesn't read all the columns. First screenshot is jmp export page not detecting the column names. Second screenshot is the excel file that has column names. Can I know how to fix this import issue?  Thank you

ClassMandrill86_0-1679340584170.png

ClassMandrill86_1-1679340709568.png

 

 

0 Kudos
10 REPLIES 10
StarfruitBob
StarfruitBob
Level VI

Re: Jmp not recognizing the column headers from excel

Mar 27, 2023 06:03 PM (430 views)  |  Posted in reply to message from ClassMandrill86 03-20-2023

If I understand your thread correctly, and you're using JMP 17, it might be related to this bug that was found.

https://community.jmp.com/t5/Discussions/Problem-Importing-Raw-Excel-Data-in-JMP-17/m-p/616405#M8160... 

Learning every day!
0 Kudos