Saving value in specific location of JMP table to specific location of excel

Question

Hi,
This is a question related to saving some values of JMP table to excel.
For example, there is JMP table like below.
I'd like to save the values of the 3rd and 4th rows of the 4th column to a specific location in excel.

For example, I’d like to save in the second and third rows (yellow parts) of the second column (B) of the Excel file.

My concern is ‘saving in specific location(column, row) of excel'.

Could this process be automated using JMP script ?

Thanks in advance

Ikju

MikeD_Anderson · Answer

I'm pretty rusty on my JMP Excel Add-in capabilities  - but I think some of what you're trying to do could be accomplished through that route.  But, I think a better question would be what is the root pain point they are trying to solve?  It sounds like the customer requirements are:

* run an analysis or series of analyses using standard jmp platforms
* package the results into a user consumable custom report
* the report format should be similar to something that's already produced in excel.

They  could generate such a report using dashboard builder (or application builder if they wanted to be fancy).  That application could be packaged as a JMP Add-in that would automate the entire process. Then they could just export the result to Powerpoint, a PDF, or use HTML5/JMP Live and retain the interactivity of the report.  All that could be done with out any real coding.

So - I'd suggest taking the spirit of the customers question and show them how JMP can exceed what they can do in excel.   Because remember, friends don't let friends us Excel.

M

IkjuShin · Answer

Hi,
I’d like to share this situation in more detail.
Many customers have many kinds of Excel standard format for data analysis and statistics.
In my experience, it seems that there are a lot of SPC related standard formats such as MSA, control chart, and capability analysis. They want to import data in Excel (or CSV) standard format into JMP, After analyzing it, and then export the analysis result back to Excel standard format.
The important thing is to export the JMP analysis results to a specific (column and row they want) location in the Excel sheet.

Many colleagues said VBA Code for this.
If so, I don't know if this has gone too far from the point of view of JMP.

Thanks

ian_jmp · Answer

Not sure if it will do it, but please take a look at @gzmorgan0 addition to this thread.