Creating an Excel Workbook from a JMP File Where Each Tab is Based on a Specific...
Our World Statistics Day conversations have been a great reminder of how much statistics can inform our lives. Do you have an example of how statistics has made a difference in your life? Share your story with the Community!
Creating an Excel Workbook from a JMP File Where Each Tab is Based on a Specific Level of a Factor
May 2, 2018 5:16 AM
Create Excel Worksheets from Master File.jsl
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.