nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

364020_en-US

liliconcom

Excel import problem

Lately, I've been having some trouble importing Excel files - trouble that I did not used to encounter. The attached file is an example - the second column does not import and I can't figure out why. If I save the file as .csv it imports correctly, but I can't understand why the Excel import does not recognize the data (text) in the second column. Any ideas?

Data Table

Re: Excel import problem

Under JMP 15.2, Windows 10, 64bit, Excel 365 the file read in with no missing columns.

Re: Excel import problem

So, this appears to be related to a problem I had with some other software. I am not running Excel 365. Is there something about the open Excel in JMP that only works correctly on Excel 365 files? I really don't understand why the version of Excel would affect the way that JMP imports the file - it was not created in Excel 365.

Comments

There are no comments yet