Jan 4, 2017 7:40 AM
| Last Modified: Jan 4, 2017 7:37 AM
Microsoft Excel has the notion of collecting sheets of data (Worksheets) into a single book (Workbook). JMP has historically not had this notion of a collecting data tables.
A request that I have heard fairly frequently is that it would be nice to be able to save a collection of JMP data tables in a single Excel workbook. JMP 13 provides this new feature.
The first thing that you will need to do is to make sure that all of the tables that you wish to save are open within JMP. Once you have done that, you can select “View -> Generate Excel Workbook”. This is the same for both JMP for Windows and JMP for Mac.
You will be presented with the dialog that allows you to customize the Workbook that you will create:
In this example, I have some JMP tables that were created by importing some movie data that we use in our Query Builder demonstration. By default, all of the visible data tables will be included in the list. If you wish to exclude a table from the Workbook, just uncheck the leftmost check box.
I’m not really thrilled with the prefixes on the names in this case. So, to change the name that will be used for the Excel worksheet, just click in the Worksheet Name edit field and change it:
I’m also not happy with the Workbook name in this case, so I select the edit box under "Workbook Name:" and replace the provided name. By default, JMP will use the name of the current, topmost data table. In this case that is g6_Rentals.
I also don’t want to save to the Documents directory, so I can use the Choose button to bring up a directory selection dialog: Now I’m ready to save out my Workbook. At this point, I can just press the Save button, and the Excel Workbook will be generated with all of my customizations. One important point to note is that only Excel 2003+ format (.xlsx) is supported for export by this feature:
There is also a JSL interface for this feature. The example below generates the same table that we created above, except to the desktop of my Windows machine. Once again, the tables to save must already be open. In this example, I have created the lists of tables and sheet names prior to the “Generate” call, but this is not required.