Excel Import

Question

Hi -

Does anyone know a way to keep a data table linked to the excel file it was orginally created from?

I need to be able to refresh the data table to capture any changes or new rows in the excel file.

I used Database > Open Table to create the table originally, and can see the script, but the option to run is greyed out.

Thanks for any help.

Mark

Wendy_Murphrey · Answer

Hi, Mark:

Take a look at the "An Example: Automating JMP From Excel 2007" section of Chapter 10 in the JMP 9 Scripting Guide.  This example demonstrates how a JMP data table (originating from Excel) can be updated automatically when individual cells are changed in the Excel worksheet.

Hope that helps!

mpb · Answer

You can add JSL code to your import script to create new columns which recreate the formulas you are using. An out of context example:

New Column( "Oxy times Age",

Numeric,

Continuous,

Format( "Best", 12 ),

Formula( :Oxy * :Age )

)

If you do this then you will always be importing the whole Excel file and recalculating the formula columns.

ron_horne · Answer

i am not aware of udating a jmp table with a colum in excel. what i would do is import the updated excel file and then use "tables >> update" or "tables >> join" in jmp.

hope it helps

ron