BookmarkSubscribeSubscribe to RSS Feed
Highlighted
hualinbai321_gm

Community Member

Joined:

Jan 25, 2015

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

2 REPLIES
pmroz

Super User

Joined:

Jun 23, 2011

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.

briancorcoran

Joined:

Jun 23, 2011

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