topic Re: import of a Excel file with column name containing formulas in Discussions

import of a Excel file with column name containing formulas

Sebastienlg — Thu, 07 Mar 2024 10:26:57 GMT

Hello all,

I would like to import an Excel file in JMP. However, the column name are formulas that allow to import names from another Excel sheet and it doesn't work. Here are the names of the imported column:

Do you know if the is a way to import a such Excel file?

Thank you in advance,

Sébastien

Re: import of a Excel file with column name containing formulas

txnelson — Thu, 07 Mar 2024 16:10:12 GMT

I suspect you will have to save the Excel Spreadsheet to a csv file and then read that into JMP

Re: import of a Excel file with column name containing formulas

Sebastienlg — Tue, 12 Mar 2024 08:36:17 GMT

Hello Jim,

Thanks for your answer. However, it is not an option to save the Excel file as a CSV...

Is there any other way to make it work?

Thanks,

Sébastien

Re: import of a Excel file with column name containing formulas

txnelson — Tue, 12 Mar 2024 13:34:38 GMT

Have you tried opening the Excel sheet, and using the JMP Addin for Excel to move the data? If the table isn't too large, you could try to cut and paste it.

Re: import of a Excel file with column name containing formulas

Sebastienlg — Fri, 15 Mar 2024 15:28:57 GMT

Jim,

Thank's a lot for you answer!

I tried the copy paste to import the data from Excel to JMP and it works!

Do you have any idea why it does not work by importing them from JMP?

Thanks a lot!

Sébastien

Re: import of a Excel file with column name containing formulas

txnelson — Fri, 15 Mar 2024 23:06:28 GMT

I suspect it has something to do with the having to do a a reference lookup from the input cell.

Re: import of a Excel file with column name containing formulas

Sebastienlg — Mon, 18 Mar 2024 15:24:13 GMT

Here is the formulae contained in the column name:

=CONCAT('SHEETAA'!$O2;" (ppb)")

Is there a way to fix it?