Exporting colour formatted Data Tables to Excel

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 5
Accepted Solution

Exporting colour formatted Data Tables to Excel

Hello

Reference this thread 

Is it possible for one to exported the colour/formatted JMP data table to Excel.

Per the referenced thread, exporting the coloured wafer/die bin-map to excel, would be extremely useful.

Please advise

Many thanks.

Nat


Accepted Solutions
Solution
‎07-10-2014 09:07 AM
SAS Employee
Posts: 224

Re: Exporting colour formatted Data Tables to Excel

The JMP community has moved to community.jmp.com. You may find that you will get a more detailed response if you post your question to the JMP users in that community.

-Renee

View solution in original post


All Replies
Super User
Super User
Posts: 7,405

Re: Exporting colour formatted Data Tables to Excel

NOt sure about JMP, however proc report can have styles/colours etc. so if you could use that...

Occasional Contributor
Posts: 5

Re: Exporting colour formatted Data Tables to Excel

Hi RW9, would you please elaborate

Many thanks

N@

Super User
Super User
Posts: 7,405

Re: Exporting colour formatted Data Tables to Excel

Sure, though not sure if it helps you.

In base SAS there is a function called proc report: Base SAS(R) 9.2 Procedures Guide

Now for any output via the SAS system you can use styles, which basically defines colors, fonts, etc. http://support.sas.com/documentation/cdl/en/proc/61895/HTML/default/viewer.htm#a000146851.htm#a00053...


Here is an article describing various templates and their associated outputs:

http://www2.sas.com/proceedings/sugi31/112-31.pdf


You can pretty much change everything in the output with a template and proc report.

Occasional Contributor
Posts: 5

Re: Exporting colour formatted Data Tables to Excel

Hi RW9

Thanks for the prompt reply.  Your method does help with fonts etc,  however its the export (to xls) of the cell formatting following jmp analysis that I'm interested in, per the wafer bin map shown in the thread I referenced i.e.

https://communities.sas.com/thread/57325

N@

Super User
Super User
Posts: 7,405

Re: Exporting colour formatted Data Tables to Excel

Yep, sorry.  Never used JMP so can't help there.

Occasional Contributor
Posts: 5

Re: Exporting colour formatted Data Tables to Excel

Apologies,  this was the thread/link that I intended   https://communities.sas.com/thread/57325

Solution
‎07-10-2014 09:07 AM
SAS Employee
Posts: 224

Re: Exporting colour formatted Data Tables to Excel

The JMP community has moved to community.jmp.com. You may find that you will get a more detailed response if you post your question to the JMP users in that community.

-Renee

Occasional Contributor
Posts: 5

Re: Exporting colour formatted Data Tables to Excel

Ops, thanks Renee...  being a new user, I guess I got lost.

N@

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 8 replies
  • 504 views
  • 0 likes
  • 3 in conversation