nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

2262_en-US

liliconcom

Excel sheet dynamically linked to data table.

Hello jmpers,
Can somebody help ? I have difficulties in building a control chart
I am trying to make a control chart which changes dynamically, for that I need that the data in my data table will change whenever the user changes a value in excel
Does someone knows how to link the excel sheet to data table dynamically?

There is an example of what I need to accomplish but this example is a simulation, in the real control chart I need to get the values from excel

Tanks a lot Pniel

Re: Excel sheet dynamically linked to data table.

I don't know the details but I think the best chance of success is to add a VB script to the Excel file that adds a row to the JMP data table whenever the value changes. Many JMP actions can be driven via OLE Automation.

Comments

There are no comments yet