4582_en-US

liliconcom

Excel Import<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />

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

Excel Import

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!

Excel Import

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.

Excel Import

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

Excel Import

thanks ron.

i tried the suggestion, and have it creating a new table. if I'm trying to keep a number of calculations (columns) running off the original data set, is there a way to replace the column data rather than create a new table?

mark

Excel Import

hi Mark,

try to copy and past the script to script window, close the table and then run it from the script window.

ron