Choose Language Hide Translation Bar
DaveLee
Community Trekker

Creating an Excel Workbook from a JMP File Where Each Tab is Based on a Specific Level of a Factor

This is a very simple script!  Although this goes against my inherent nature, sometimes I'm forced to take data from JMP and put it into Excel. I recently had to do this where I needed to parse out data from an original JMP datatable and save into one Excel file where each worksheet is saved with the title of the level of that factor. 

 

In this example, I create a data tble of 500 rows with 5 levels of Dev ID ( A thru E).  I'd like to get to one Excel file called 'Sample' where there are 5 worksheets titled A, B, C, D & E.

 

Thanks to Wendy Murphrey for helping me.

Comments
GM

Hi David,
Thanks for posting this example.
When I ran the script attached to your post I received the following error:
None of the specified tables could be found. Save failed.
None of the specified tables could be found. Save failed.
None of the specified tables could be found. Save failed.
None of the specified tables could be found. Save failed.
None of the specified tables could be found. Save failed.
So, I changed

 

Create Excel Workbook(
"$DOCUMENTS\Sample.xlsx",
{sub}, // data table references
list[i]

to

 

Create Excel Workbook(
"$DOCUMENTS\Sample.xlsx",
list,// data table references
list

 

and now it works perfect.
Thanks again!
Sincerely,

Matt Goodlaw

DaveLee

Hi Matt,

 

I don't know why you get that error but I just pulled the script right from the website and it worked fine as is.  It's good to knwo alternate means to get the same result though.  Thanks for theh feedback!

 

Dave

GM

Might be the version of JMP I am using.

DaveLee

True. I'm using v14.

Article Labels
Article Tags
Contributors