Subscribe Bookmark RSS Feed

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

hualinbai321_gm

Community Member

Joined:

Jan 25, 2015

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

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

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

Brian Corcoran

JMP Development