BookmarkSubscribe
Choose Language Hide Translation Bar
hualinbai321_gm
Community Member

how to save the color coded jmp data table to excel file with the same color code?

Does anyone know how to save the color coded jmp data table to excel file with the same color code? Thanks

0 Kudos
2 REPLIES 2
pmroz
Super User

Re: how to save the color coded jmp data table to excel file with the same color code?

To my knowledge this is not supported directly.  I've taken an approach, that while a bit complicated, yields great results:

1. I create an Excel workbook "template" that looks exactly how I want it to look (colors, multiple tabs, fonts, etc.)

2. Save this spreadsheet with the filetype of XML spreadsheet 2003 *.xml.

3. This is the hard part: reverse engineer the XML file using JSL.  This requires knowledge of JSL and some understanding of XML.

Re: how to save the color coded jmp data table to excel file with the same color code?

JMP 12 will automatically save colored data table cells to the Excel spreadsheet.

Brian Corcoran

JMP Development