topic Re: Can you add outline to Data table when saving as image? in Discussions

Can you add outline to Data table when saving as image?

skumar0789 — Tue, 28 Jan 2020 18:56:23 GMT

I am creating summary tables using JSL and want to save them as images. I was able to get that to work, thanks to another post from the JMP community.

However, the image is always saved with all the borders removed which makes it hard to read at times.

Here is my sample code :

mypath = "C:/JSL/";
Set Current Directory( mypath );   //sets output directory to variable 'mypath'
DT = Data Table( "Try" );

DT << journal;
jrnl1 = current journal();
jrnl1 <<Save picture (mypath || "Sample_summary_table"|| ".png");
jrnl1 << close window;

"Try" table that I used above:

Title	ROW	N Rows
17	-12	6
17	-11	7
17	-10	11
17	-9	10
17	-8	12

Output image "Sample_summary_table" that I am getting:

I would like to get something like an excel table with outlines:

Re: Can you add outline to Data table when saving as image?

txnelson — Tue, 28 Jan 2020 22:27:16 GMT

Here is an example of how I have done this in the past....it is a little bit of a kluge, but it works

names default to here(1);
dt=open("$SAMPLE_DATA/big class.jmp");
myjournal = dt <<journal;
wait(0);
nw = New window("example",<<journal, bb = border box(top(1),left(10),right(1),bottom(1),
	sides(15)
));

bb<<append(myjournal);
myjournal << close window;
xx=nw<<get picture;

Re: Can you add outline to Data table when saving as image?

skumar0789 — Tue, 11 Feb 2020 18:33:56 GMT

Thanks @txnelson . That will work for sure. I ended up making the summary tables using Python scripts instead. I found them to be a bit more user friendly when exporting tables to a powerpoint.

Re: Can you add outline to Data table when saving as image?

txnelson — Tue, 11 Feb 2020 19:07:06 GMT

Whatever "flicks your Bic"...…...you have to be old to have heard that old saying