cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Check out the JMP® Marketplace featured Capability Explorer add-in
Choose Language Hide Translation Bar
skumar0789
Level I

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

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:

TitleROWN Rows
17-126
17-117
17-1011
17-910
17-812

 

Output image "Sample_summary_table" that I am getting:

skumar0789_1-1580237358530.png

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

image.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
txnelson
Super User

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

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

.border.PNG

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;
Jim

View solution in original post

3 REPLIES 3
txnelson
Super User

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

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

.border.PNG

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;
Jim
skumar0789
Level I

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

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.

txnelson
Super User

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

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

Jim