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: 
Browse apps to extend the software in the new JMP Marketplace
Choose Language Hide Translation Bar
dale_lehman
dale_lehman
Level VII

Excel import problem

Created: Mar 1, 2021 02:49 PM  |  Last Modified: Jun 10, 2023 4:26 PM (3432 views)

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?

Preview file
61 KB
0 Kudos
1 ACCEPTED SOLUTION

Accepted Solutions
statman
Super User statman
Super User
Solution

Re: Excel import problem

Mar 1, 2021 04:58 PM (3396 views)  |  Posted in reply to message from dale_lehman 03-01-2021

Are you using the import wizard?  Check to see how many columns to import it is set to.  Worked fine for me on 15.2 on a Mac not using 365.

"All models are wrong, some are useful" G.E.P. Box

View solution in original post

0 Kudos
5 REPLIES 5
txnelson
Super User txnelson
Super User

Re: Excel import problem

Mar 1, 2021 03:25 PM (3423 views)  |  Posted in reply to message from dale_lehman 03-01-2021
Under JMP 15.2, Windows 10, 64bit, Excel 365 the file read in with no missing columns.
Jim
0 Kudos
dale_lehman
dale_lehman
Level VII

Re: Excel import problem

Mar 1, 2021 04:34 PM (3411 views)  |  Posted in reply to message from txnelson 03-01-2021

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.

0 Kudos
dale_lehman
dale_lehman
Level VII

Re: Excel import problem

Mar 1, 2021 04:57 PM (3400 views)  |  Posted in reply to message from txnelson 03-01-2021

So I installed Excel365.  The file open still does not recognize the second column.  I have both 365 and Excel2010 on my machine.  Do I have to tell JMP something special in order to get the file recognized properly?  Again, I don't understand why my version of Excel should affect the way the JMP Excel Wizard works.

0 Kudos
statman
Super User statman
Super User
Solution

Re: Excel import problem

Mar 1, 2021 04:58 PM (3397 views)  |  Posted in reply to message from dale_lehman 03-01-2021

Are you using the import wizard?  Check to see how many columns to import it is set to.  Worked fine for me on 15.2 on a Mac not using 365.

"All models are wrong, some are useful" G.E.P. Box
0 Kudos
dale_lehman
dale_lehman
Level VII

Re: Excel import problem

Mar 1, 2021 05:13 PM (3375 views)  |  Posted in reply to message from statman 03-01-2021
Well, I did not see a setting for number of columns - and there are not so many columns - and it was the second column that was not importing, but the others did. However, I clicked Restore Defaults and it now works. I don't know what settings got changed and I am not even sure where those settings reside (I don't see them under Preferences), but apparently something got modified from the original settings. So, it works and thanks. If anyone can shed light on where those settings are found, I'd be interested.
0 Kudos