topic export JMP into excel with row states in Discussions

export JMP into excel with row states

emmablue — Tue, 27 Aug 2024 20:48:46 GMT

Hello, I'm using a script to select some rows in JMP and color the rows, but I need to share the table with some non-JMP users. Would it be possible to export JMP into excel with row states like coloring and labeling of individual rows? Thanks!

Re: export JMP into excel with row states

jthi — Wed, 28 Aug 2024 05:43:22 GMT

I think JMP can export colored cells to Excel but not row states. For row states you might have to add extra columns to indicate them or create a single row state column which they then would have to be able to decrypt.

Red cells here have been colored by "Color by Row State" and for that reason are not copied over. Time Marker column demonstrates row state column

Some stuff to read about row states https://www.jmp.com/support/help/en/18.0/#page/jmp/row-states.shtml

Re: export JMP into excel with row states

emmablue — Wed, 28 Aug 2024 16:04:37 GMT

It's a great idea to create a new column for row state. Thank you!!

Re: export JMP into excel with row states

jthi — Wed, 28 Aug 2024 16:22:55 GMT

Functions like Labeled(), Excluded(), Hidden() and so on might be useful when adding new columns