turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- JMP User Community
- :
- Discussions
- :
- Discussions
- :
- Importing JMP equations to Excel

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Nov 18, 2011 4:43 PM
(1224 views)

Hi, I wonder if ther's a way to import a huge equation I've got in JMP (using SCREENING) to an Excel spreadsheet, and not only the values. Any ideas?

Thanks

Alvaro Gil

3 REPLIES

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Nov 22, 2011 5:22 AM
(994 views)

Please some answer... thanks!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Nov 22, 2011 5:57 AM
(994 views)

The short answer is no ... in the sense there is no menu option to do it for you, so you either have to do it manually or write some code to automate the process.

-Dave

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Nov 26, 2011 9:09 AM
(994 views)

Hi:

Here is one roundabout way - using the R functions in JMP 9 and the on Windoze via COM and the RDCOMClient package:

// datatable: / File Save As() - (saves values and not formulas) - save as a "c:/temp/.xls"

Insert formula in a colum in Excel via R and RDCOMClient

// http://www.omegahat.org/RDCOMClient/

Clear Log();

R Submit("\[

library(RDCOMClient);

xcel <<- COMCreate("EXCEL.Application")

xcel[["Visible"]] <- TRUE

xcel[["Workbooks"]]$Open("C:/temp/test.xls");

sh <- xcel$ActiveSheet()

r <- sh$Range("D1")

r[["Value"]] = "Formula"

for(i in 2:51) {

r <- sh$Range(sh$Cells(i, 4),sh$Cells(i, 4))

# insert your desired foumula here

r[["Formula"]] <- paste("=Sum(A",i,":B",i,")",sep="")

}

]\");

// now close R

R Term();

Best regards,

-Matt