topic Re: Jmp not recognizing the column headers from excel in Discussions

Jmp not recognizing the column headers from excel

ClassMandrill86 — Thu, 08 Jun 2023 16:27:06 GMT

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

Re: Jmp not recognizing the column headers from excel

txnelson — Mon, 20 Mar 2023 21:25:48 GMT

There are multiple methods available to "Import" an Excel file. Will you please be more specific in the description of what method you are using when importing?

Re: Jmp not recognizing the column headers from excel

ClassMandrill86 — Tue, 21 Mar 2023 12:35:43 GMT

Sure, I clicked on File->Open-->Browsed and selected the Excel file I mentioned, then got to the page1 of import screen shown in the post. No matter how I adjusted the settings for header rows position, the file is not being read properly. Thanks

Re: Jmp not recognizing the column headers from excel

txnelson — Tue, 21 Mar 2023 12:51:25 GMT

I suggest that you use the Excel Wizard to import the data. It will allow you to change settings and see a preview of how the data are going to be imported.

To get to the Wizard, click on the down arrow on the Open select box and select Excel Wizard

Re: Jmp not recognizing the column headers from excel

ClassMandrill86 — Tue, 21 Mar 2023 13:07:20 GMT

Also, when this import is successful, I would like to use the generated jmp script to update the new rows of data from the same excel file when it is updated.

Re: Jmp not recognizing the column headers from excel

txnelson — Tue, 21 Mar 2023 13:21:13 GMT

The JSL the Wizard creates is placed into the Source entry of the imported data table.

Re: Jmp not recognizing the column headers from excel

ClassMandrill86 — Thu, 23 Mar 2023 14:56:54 GMT

Hi Nelson, Thanks for the response again. Yes, the screenshot I posted was from Excel wizard import page, below are the settings. Default preview settings or changing them is not making any difference the way jmp reads the file. Here is another screenshot and of the script it generated which is also not correct.

Re: Jmp not recognizing the column headers from excel

txnelson — Thu, 23 Mar 2023 17:22:05 GMT

Would you please attach a copy of your Excel file, so I can explore what might be going on. If you can not attach the file, then you need to get in touch with JMP support( support@jmp.com ) where you can work with them for resolution

Re: Jmp not recognizing the column headers from excel

ClassMandrill86 — Fri, 24 Mar 2023 14:17:29 GMT

Thank you, I wont be able to attach the data here. Hence, submitted a support ticket.

Re: Jmp not recognizing the column headers from excel

FN — Mon, 27 Mar 2023 16:04:01 GMT

If the headers contain combined cells, Excel import can struggle. Only the Wizard (not the add-in) can handle this.

For the update, you can use the Source script as a starting point, but table manipulations must be put together in a JSL script.

Take a look at this wish so a simpler interface is provided.

https://community.jmp.com/t5/JMP-Wish-List/Wizard-to-update-Excel-files-in-place-no-code-solution/idi-p/608145

Re: Jmp not recognizing the column headers from excel

StarfruitBob — Mon, 27 Mar 2023 22:03:49 GMT

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#M81606