Is JMP 12 unable to import xls/xlsx as JMP 11?

saitcopuroglu

Being a Mac user is always a disadvantage when it comes to JMP. Finally we now have xlsx import future but it seems to be worse than JMP 11. Mainly I import xls/xlsx files and then join them with other jmp data tables. Hence JMP 12 can not read the column formats (importing all the columns as character) I have to write scripts for each column data type. Better solution is still using JMP 11 for importing. Am i doing something wrong? If yes please let me know if no please developers, do something for exact data type reading capabilities of JMP 12.

JMP 11 xls import:

JMP 12 xlsx import:

briancorcoran

Hello Sait,

If you have character and numeric data mixed in a column, or a lot of missing data, JMP 12 will be more strict about making the column character.  The reason is that we received reports of lost character data when the column was mainly numeric or missing.  Customers were unhappy that any data was lost.

Brian Corcoran

JMP Development