Import Png pics in each cell

[#1]

Hello,

Is there a way to import the Histogram (.png) pictures into the excel cell (fit the cell by image) using jsl?

Something like this.....

Jackie__0-1709219913225.png

JSL to iterate over column groups to export the pictures

Names Default To Here( 1 );
dt2= Open( "$SAMPLE_DATA/Semiconductor Capability.jmp" );
maindir = Pick Directory( "Choose a directory to save distribution images" );
distributiondir = Concat( maindir || "/Distribution_Images" );


Col_List = dt2 << Get Column Group( "Processes" );

dt2 << select column group( "Processes" );
TestName = dt2 << Get Selected Columns;
Tests = N Items( Col_List );							

Create Directory( distributiondir );

Caption( "Processing....." );
wait(0);

For( ii = 1, ii <= Tests, ii++,
Caption( "Processing..... " || char(ii) || " of " || char(Tests), Font Size(13), spoken(0) );
	vc2 = dt2 << distribution(
		Stack( 1 ),
		Continuous Distribution(
			Column(TestName[ii] ),
			Horizontal Layout( 1 ),
			Normal Quantile Plot( 1 ),
			Customize Summary Statistics(
			Std Err Mean( 0 ),
			Upper Mean Confidence Interval( 0 ),
			Lower Mean Confidence Interval( 0 )
		),
			Vertical( 1 ),
			Process Capability( 0 )
			
		)
	);



	vc2 << Save Picture( distributiondir || "/" || Char( ii ) || ".png", "png" );
	vc2 << Close Window;
);

Caption( "Saved!!!!" );
wait(0.4);

Caption( remove);
wait(0);

Thanks,

Jackie

[#2]

I think you would have to use something else with JMP. Use JMP to save images to directory and then some other software/programming language (python, vbscript, excel macro, powershell, ....) to move those images to excel cells

Copying PNG images from JMP file to Excel 

data table with images -> Excel 

[#3]

I was able to get this far: journal a data table with images, save-as RTF. In OpenOffice Writer, the RTF looks pretty good. It is in a table element that copies with rows and columns. Unfortunately OpenOffice calc does not paste the pictures. (I did pick PNG for the RTF picture format.)

You might try copy/paste this table from MS Word to MS Excel and get different results