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

[#1]

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.

[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.