Choose Language Hide Translation Bar
Highlighted
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
Highlighted
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
Highlighted
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

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

Highlighted
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
Article Labels

    There are no labels assigned to this post.