Subscribe Bookmark RSS Feed

jmp10 excel import column 1 as header

anneg

Community Trekker

Joined:

Jun 23, 2011

Hello,

I don't find in jmp 10 in the preferences the "use Excel labels as Heading "Always"" like in jmp9, so the problem is, that the first column in an excel spreadsheet isn't recognized as a heading.

jmp9 - preferences:

1946_jmp9.jpg

jmp10 - preferences:

1947_jmp10.jpg

also in jmp10 this doesn't do the trick (column Names are on line 1; data starts on line 2:

1948_jmp10_text.jpg

If I open it manually I can choose - always enforce ExcelRow1 as labels:1949_jmp10_excel_import.jpg

but it isn't saved for the next excel file and that ist frustrating, because every script with excel import doesnt work either in jmp10.

Is there any solution to this problem?

Thanks in advance.

1 REPLY
bwanders

Community Trekker

Joined:

Sep 20, 2013

Click on JMP in the Excel toolbar, then click on  "preferences".  You will see where to check the box for "Use first rows as column names"