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; } } }

395286_en-US

liliconcom

Dynamically fill out JMP data table with Excel

I'm using JMP 16 and would like to know if there was an easy way for JMP to automatically fill out the data table as I make changes to it on Excel. Right now I keep having to save each file and copy and paste my scripts over but that gets cumbersome as I make a small change in Excel.

Thanks!

Analytics

Data Table

Scripting

Re: Dynamically fill out JMP data table with Excel

Using the JMP Add In for Excel would allow you to move all of the data from your Excel spreadsheet into JMP after any change, with one click. You were not specific about where the scripts that you copy and paste are coming from, but I am pretty sure the moving of them could be accomplished by running a simple script that could be installed as a JMP Addin. If you can provide more specifics, I am sure the community will be able to help you with minimizing your efforts.

Re: Dynamically fill out JMP data table with Excel

Thank you. The scripts were things on graph builder that I made myself. I have the JMP Add In but it opens a new file every time - is there a way to keep it in the same file?

Re: Dynamically fill out JMP data table with Excel

Yes the Add In will create a new data table, but a very simple script can be run with another simple click, that will copy the scripts into the new data table, and then delete the old table.

Comments

There are no comments yet