cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
%3CLINGO-SUB%20id%3D%22lingo-sub-730412%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%EC%88%98%EC%8B%9D%EC%9D%B4%20%ED%8F%AC%ED%95%A8%EB%90%9C%20%EC%97%B4%20%EC%9D%B4%EB%A6%84%EC%9D%B4%20%EC%9E%88%EB%8A%94%20Excel%20%ED%8C%8C%EC%9D%BC%20%EA%B0%80%EC%A0%B8%EC%98%A4%EA%B8%B0%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-730412%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3E%EB%AA%A8%EB%91%90%EB%93%A4%20%EC%95%88%EB%85%95%2C%3C%2FP%3E%3CP%3E%20%3C%2FP%3E%3CP%3EJMP%EC%97%90%EC%84%9C%20Excel%20%ED%8C%8C%EC%9D%BC%EC%9D%84%20%EA%B0%80%EC%A0%B8%EC%98%A4%EA%B3%A0%20%EC%8B%B6%EC%8A%B5%EB%8B%88%EB%8B%A4.%20%EA%B7%B8%EB%9F%AC%EB%82%98%20%EC%97%B4%20%EC%9D%B4%EB%A6%84%EC%9D%80%20%EB%8B%A4%EB%A5%B8%20Excel%20%EC%8B%9C%ED%8A%B8%EC%97%90%EC%84%9C%20%EC%9D%B4%EB%A6%84%EC%9D%84%20%EA%B0%80%EC%A0%B8%EC%98%AC%20%EC%88%98%20%EC%9E%88%EB%8A%94%20%EC%88%98%EC%8B%9D%EC%9D%B4%EB%AF%80%EB%A1%9C%20%EC%9E%91%EB%8F%99%ED%95%98%EC%A7%80%20%EC%95%8A%EC%8A%B5%EB%8B%88%EB%8B%A4.%20%EA%B0%80%EC%A0%B8%EC%98%A8%20%EC%97%B4%EC%9D%98%20%EC%9D%B4%EB%A6%84%EC%9D%80%20%EB%8B%A4%EC%9D%8C%EA%B3%BC%20%EA%B0%99%EC%8A%B5%EB%8B%88%EB%8B%A4.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Sebastienlg_0-1709807094850.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Sebastienlg_0-1709807094850.png%22%20style%3D%22width%3A%20184px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Sebastienlg_0-1709807094850.png%22%20style%3D%22width%3A%20184px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Sebastienlg_0-1709807094850.png%22%20style%3D%22width%3A%20184px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Sebastienlg_0-1709807094850.png%22%20style%3D%22width%3A%20184px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Sebastienlg_0-1709807094850.png%22%20style%3D%22width%3A%20184px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Sebastienlg_0-1709807094850.png%22%20style%3D%22width%3A%20184px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Sebastienlg_0-1709807094850.png%22%20style%3D%22width%3A%20184px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F61923iA4ACF17E71EE5D0B%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Sebastienlg_0-1709807094850.png%22%20alt%3D%22Sebastienlg_0-1709807094850.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%EC%9D%B4%EB%9F%AC%ED%95%9C%20Excel%20%ED%8C%8C%EC%9D%BC%EC%9D%84%20%EA%B0%80%EC%A0%B8%EC%98%A4%EB%8A%94%20%EB%B0%A9%EB%B2%95%EC%9D%B4%20%EC%9E%88%EB%8A%94%EC%A7%80%20%EC%95%8C%EA%B3%A0%20%EA%B3%84%EC%8B%AD%EB%8B%88%EA%B9%8C%3F%3C%2FP%3E%3CP%3E%20%3C%2FP%3E%3CP%3E%EB%AF%B8%EB%A6%AC%20%EA%B0%90%EC%82%AC%EB%93%9C%EB%A6%BD%EB%8B%88%EB%8B%A4.%3C%2FP%3E%3CP%3E%EC%84%B8%EB%B0%94%EC%8A%A4%EC%B0%AC%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-730412%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CLINGO-LABEL%3E%EC%9E%90%EB%8F%99%ED%99%94%20%EB%B0%8F%20%EC%8A%A4%ED%81%AC%EB%A6%BD%ED%8C%85%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-730491%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ERe%3A%20%EC%88%98%EC%8B%9D%EC%9D%B4%20%ED%8F%AC%ED%95%A8%EB%90%9C%20%EC%97%B4%20%EC%9D%B4%EB%A6%84%EC%9D%B4%20%EC%9E%88%EB%8A%94%20Excel%20%ED%8C%8C%EC%9D%BC%20%EA%B0%80%EC%A0%B8%EC%98%A4%EA%B8%B0%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-730491%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EExcel%20%EC%8A%A4%ED%94%84%EB%A0%88%EB%93%9C%EC%8B%9C%ED%8A%B8%EB%A5%BC%20csv%20%ED%8C%8C%EC%9D%BC%EB%A1%9C%20%EC%A0%80%EC%9E%A5%ED%95%9C%20%EB%8B%A4%EC%9D%8C%20%EC%9D%B4%EB%A5%BC%20JMP%EB%A1%9C%20%EC%9D%BD%EC%96%B4%EC%95%BC%20%ED%95%A0%20%EA%B2%83%20%EA%B0%99%EC%8A%B5%EB%8B%88%EB%8B%A4.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-733194%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ERe%3A%20%EC%88%98%EC%8B%9D%EC%9D%B4%20%ED%8F%AC%ED%95%A8%EB%90%9C%20%EC%97%B4%20%EC%9D%B4%EB%A6%84%EC%9D%B4%20%EC%9E%88%EB%8A%94%20Excel%20%ED%8C%8C%EC%9D%BC%20%EA%B0%80%EC%A0%B8%EC%98%A4%EA%B8%B0%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-733194%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3E%EC%95%88%EB%85%95%ED%95%98%EC%84%B8%EC%9A%94%20%EC%A7%90%2C%3C%2FP%3E%3CP%3E%EB%8B%B5%EB%B3%80%ED%95%B4%20%EC%A3%BC%EC%85%94%EC%84%9C%20%EA%B0%90%EC%82%AC%ED%95%A9%EB%8B%88%EB%8B%A4.%20%EB%8B%A4%EB%A7%8C%2C%20%EC%97%91%EC%85%80%20%ED%8C%8C%EC%9D%BC%EC%9D%84%20CSV%EB%A1%9C%20%EC%A0%80%EC%9E%A5%ED%95%98%EB%8A%94%20%EA%B2%83%EC%9D%80%20%EC%98%B5%EC%85%98%EC%9D%B4%20%EC%95%84%EB%8B%99%EB%8B%88%EB%8B%A4...%3C%2FP%3E%3CP%3E%EC%9E%91%EB%8F%99%ED%95%98%EA%B2%8C%20%ED%95%98%EB%8A%94%20%EB%8B%A4%EB%A5%B8%20%EB%B0%A9%EB%B2%95%EC%9D%B4%20%EC%9E%88%EB%82%98%EC%9A%94%3F%3C%2FP%3E%3CP%3E%EA%B0%90%EC%82%AC%ED%95%B4%EC%9A%94%2C%3C%2FP%3E%3CP%3E%EC%84%B8%EB%B0%94%EC%8A%A4%EC%B0%AC%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-733325%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ERe%3A%20%EC%88%98%EC%8B%9D%EC%9D%B4%20%ED%8F%AC%ED%95%A8%EB%90%9C%20%EC%97%B4%20%EC%9D%B4%EB%A6%84%EC%9D%B4%20%EC%9E%88%EB%8A%94%20Excel%20%ED%8C%8C%EC%9D%BC%20%EA%B0%80%EC%A0%B8%EC%98%A4%EA%B8%B0%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-733325%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EExcel%20%EC%8B%9C%ED%8A%B8%EB%A5%BC%20%EC%97%B4%EA%B3%A0%20Excel%EC%9A%A9%20JMP%20%EC%B6%94%EA%B0%80%20%EA%B8%B0%EB%8A%A5%EC%9D%84%20%EC%82%AC%EC%9A%A9%ED%95%98%EC%97%AC%20%EB%8D%B0%EC%9D%B4%ED%84%B0%EB%A5%BC%20%EC%9D%B4%EB%8F%99%ED%95%B4%20%EB%B3%B4%EC%85%A8%EB%82%98%EC%9A%94%3F%20%ED%85%8C%EC%9D%B4%EB%B8%94%EC%9D%B4%20%EB%84%88%EB%AC%B4%20%ED%81%AC%EC%A7%80%20%EC%95%8A%EB%8B%A4%EB%A9%B4%20%EC%9E%98%EB%9D%BC%EC%84%9C%20%EB%B6%99%EC%97%AC%EB%84%A3%EC%9D%84%20%EC%88%98%EB%8F%84%20%EC%9E%88%EC%8A%B5%EB%8B%88%EB%8B%A4.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-735367%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ERe%3A%20%EC%88%98%EC%8B%9D%EC%9D%B4%20%ED%8F%AC%ED%95%A8%EB%90%9C%20%EC%97%B4%20%EC%9D%B4%EB%A6%84%EC%9D%B4%20%EC%9E%88%EB%8A%94%20Excel%20%ED%8C%8C%EC%9D%BC%20%EA%B0%80%EC%A0%B8%EC%98%A4%EA%B8%B0%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-735367%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3E%EC%97%B4%20%EC%9D%B4%EB%A6%84%EC%97%90%20%ED%8F%AC%ED%95%A8%EB%90%9C%20%EC%88%98%EC%8B%9D%EC%9D%80%20%EB%8B%A4%EC%9D%8C%EA%B3%BC%20%EA%B0%99%EC%8A%B5%EB%8B%88%EB%8B%A4.%3C%2FP%3E%3CP%3E%3DCONCAT('SHEETAA'!%24O2%3B%22%20(ppb)%22)%3C%2FP%3E%3CP%3E%EB%AC%B8%EC%A0%9C%EB%A5%BC%20%ED%95%B4%EA%B2%B0%ED%95%A0%20%EC%88%98%20%EC%9E%88%EB%8A%94%20%EB%B0%A9%EB%B2%95%EC%9D%B4%20%EC%9E%88%EB%82%98%EC%9A%94%3F%3C%2FP%3E%3CP%3E%20%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-735198%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ERe%3A%20%EC%88%98%EC%8B%9D%EC%9D%B4%20%ED%8F%AC%ED%95%A8%EB%90%9C%20%EC%97%B4%20%EC%9D%B4%EB%A6%84%EC%9D%B4%20%EC%9E%88%EB%8A%94%20Excel%20%ED%8C%8C%EC%9D%BC%20%EA%B0%80%EC%A0%B8%EC%98%A4%EA%B8%B0%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-735198%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3E%EC%A7%90%2C%3C%2FP%3E%3CP%3E%EB%8B%B5%EB%B3%80%ED%95%B4%20%EC%A3%BC%EC%85%94%EC%84%9C%20%EC%A0%95%EB%A7%90%20%EA%B0%90%EC%82%AC%ED%95%A9%EB%8B%88%EB%8B%A4!%3C%2FP%3E%3CP%3EExcel%EC%97%90%EC%84%9C%20JMP%EB%A1%9C%20%EB%8D%B0%EC%9D%B4%ED%84%B0%EB%A5%BC%20%EA%B0%80%EC%A0%B8%EC%98%A4%EA%B8%B0%20%EC%9C%84%ED%95%B4%20%EB%B3%B5%EC%82%AC%20%EB%B6%99%EC%97%AC%EB%84%A3%EA%B8%B0%EB%A5%BC%20%EC%8B%9C%EB%8F%84%ED%96%88%EB%8A%94%EB%8D%B0%20%EC%9E%91%EB%8F%99%ED%96%88%EC%8A%B5%EB%8B%88%EB%8B%A4!%3C%2FP%3E%3CP%3EJMP%EC%97%90%EC%84%9C%20%EA%B0%80%EC%A0%B8%EC%98%A4%EB%A9%B4%20%EC%99%9C%20%EC%9E%91%EB%8F%99%ED%95%98%EC%A7%80%20%EC%95%8A%EB%8A%94%EC%A7%80%20%EC%95%84%EC%8B%9C%EB%82%98%EC%9A%94%3F%3C%2FP%3E%3CP%3E%EC%A0%95%EB%A7%90%20%EA%B0%90%EC%82%AC%ED%95%A9%EB%8B%88%EB%8B%A4!%3C%2FP%3E%3CP%3E%EC%84%B8%EB%B0%94%EC%8A%A4%EC%B0%AC%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-735237%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ERe%3A%20%EC%88%98%EC%8B%9D%EC%9D%B4%20%ED%8F%AC%ED%95%A8%EB%90%9C%20%EC%97%B4%20%EC%9D%B4%EB%A6%84%EC%9D%B4%20%EC%9E%88%EB%8A%94%20Excel%20%ED%8C%8C%EC%9D%BC%20%EA%B0%80%EC%A0%B8%EC%98%A4%EA%B8%B0%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-735237%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3E%EC%9E%85%EB%A0%A5%20%EC%85%80%EC%97%90%EC%84%9C%20%EC%B0%B8%EC%A1%B0%20%EC%A1%B0%ED%9A%8C%EB%A5%BC%20%EC%88%98%ED%96%89%ED%95%B4%EC%95%BC%20%ED%95%98%EB%8A%94%20%EA%B2%83%EA%B3%BC%20%EA%B4%80%EB%A0%A8%EC%9D%B4%20%EC%9E%88%EB%8A%94%20%EA%B2%83%EC%9C%BC%EB%A1%9C%20%EC%83%9D%EA%B0%81%EB%90%A9%EB%8B%88%EB%8B%A4.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Choose Language Hide Translation Bar
Sebastienlg
Level II

import of a Excel file with column name containing formulas

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:

Sebastienlg_0-1709807094850.png

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

 

Thank you in advance,

Sébastien

6 REPLIES 6
txnelson
Super User

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

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

Jim
Sebastienlg
Level II

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

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

txnelson
Super User

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

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.

Jim
Sebastienlg
Level II

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

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

txnelson
Super User

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

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

Jim
Sebastienlg
Level II

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

Here is the formulae contained in the column name:

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

Is there a way to fix it?