topic Exporting a Table with Spec Limits to Excel in Discussions

Exporting a Table with Spec Limits to Excel

SpannerHead — Tue, 01 Apr 2025 16:22:11 GMT

I have a JMP data table with embedded Spec Limits and Notes. Anyone ever export something like that to Excel and retain the Column Properties somehow?

Re: Exporting a Table with Spec Limits to Excel

shampton82 — Tue, 01 Apr 2025 17:27:27 GMT

Hey @SpannerHead ,

You can't directly export the spec limits but you could make a table with JSL and then save that table as an excel table. If you want to do it without JSL you can use the Manage Limits platform to save out the spec limits to a JMP table and then save that to excel.

Steve

Re: Exporting a Table with Spec Limits to Excel

SpannerHead — Tue, 01 Apr 2025 18:30:11 GMT

To grab the notes, I used this. I can export this separately to Excel.

dt = Current Data Table();

rej = dt << Get Column Group( "REJ");

notes_list = {};

For( i = 1, i <= N Items( rej ), i++,
	prop = rej[i] << Get Property( "Notes" );
		insert into(notes_list, prop);

);

dt = New Table( "Notes Data" );
dt << New Column( "Parameter", Character, Values( rej ) );
dt << New Column( "Notes", Character, Values( notes_list ) );