Description
Have you ever needed to share data and collaborate with a colleague who is not a JMP user? Perhaps you export data to Excel for those colleagues, only to lose the JMP formulas, table scripts, and other column properties when you bring the updated data back to JMP. This add-in enables you to export a JMP data table to an Excel workbook along with the table and column properties of the original JMP table in a separate worksheet. Your colleague can then update or modify the data to send back to you. When you import the workbook back into JMP, all of your table scripts, column properties, and even column formulas will be automatically restored. This Add-In will also allow you to generate an attribute table for any JMP data table.
Menu Items
JMP Attribute Table
Create an attribute table for the current data table.
JMP Attribute Table
Add Attribute Table Script
Add a script to the current data table that will create an attribute table.
"Create Attribute Table" Table Script
Export Workbook with Attributes
Export table(s) to an Excel workbook with sheets for column and table attributes.
Export Workbook Dialog
Exported Excel Workbook
Import Workbook with Attributes
Import table(s) from an Excel workbook with all column properties and table variables/scripts.
Import Workbook Dialog
Check out my blog post JMP to Excel and back again -- all without losing any table attributes
System Requirements
This add-in is supported for JMP 13 and higher.
Updates
Version 1.1 (June 20, 2017)
- Fixed issue where you get an error when canceling the selection of a data table.
- Fixed issue where character columns with a formula caused an extra column to be created in the attribute table
- Fixed issue where validation column properties caused an error when importing the a table.
Version 1.2 (June 21, 2017)
- Added support for Mac operating systems.
- Added a prompt when file being overwritten is locked by another process.
Version 1.3 (June 27, 2017)
- Made a change so that progress bar appears when export process takes a while. Also, an alert message now appears when there are more rows in the data table than Excel supports within a single sheet.
Version 1.4 (November 21, 2017)
- Added support for all** column properties.
**Let me know if there's one that does not work, as I did not test them all.
Version 1.5 (January 29, 2018)
- Added support for maintaining column groups when exporting/importing.
Version 1.6 (March 12, 2018)
- Fixed rare issue causing column names not to be imported properly.
Version 1.7 (April 6, 2018)
- Added the data type length to the Data Type column
Version 1.8 (April 10, 2018)
- Fixes some cases where formats were not applied correctly when importing from Excel workbook.
- Removed extra Source script that was not in the original table when importing from Excel workbook.
Version 2.0 (January 9, 2020)
- Added warning messages for properties that were unable to be imported instead of failing to complete other properties
- Other architecture improvements.
Version 2.1 (January 10, 2020)
- Fix import of empty columns.
- Better warnings when number of columns in the data do not match number of columns listed in the attribute sheet.
Version 2.2 (February 28, 2024)
- Fix error message thrown for some tables on Mac