import of a Excel file with column name containing formulas

[#1]

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

[#2]

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

[#3]

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

[#4]

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.

[#5]

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

[#6]

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

[#7]

Here is the formulae contained in the column name:

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

Is there a way to fix it?