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 Jackie__0-1709219913225.png](https://community.jmp.com/t5/image/serverpage/image-id/61679i063F4E4D1D916486/image-size/medium?v=v2&px=400)
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