topic Re: Import Png pics in each cell in Discussions

Import Png pics in each cell

Jackie_ — Thu, 29 Feb 2024 15:20:34 GMT

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.....

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

Re: Import Png pics in each cell

jthi — Thu, 29 Feb 2024 15:46:54 GMT

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

Re: Import Png pics in each cell

Craige_Hales — Thu, 29 Feb 2024 16:49:43 GMT

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