topic Re: data table with images -> Excel in Discussions

data table with images -> Excel

hogi — Thu, 08 Jun 2023 16:40:23 GMT

Is it possible to save a data Table with Images to Excel such that the images get saved?

Unfortunately, the default mode is that the image is saved as a Char of a Blob:

The Background:

The command Make Into Data Table in GraphBuilder is very useful - it generates a new data table with all the subplots of the GraphBuilder platform :)

Actually amazing!

But if I want to share the table with some colleagues, is it possible to save this table (and the images as such) as an Excel ?

Names Default to Here(1);
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );

gb = dt << Graph Builder(
	Variables( X( :weight ), Y( :height ), Group X( :age ), Group Y( :sex ) ),
	Elements( Points( X, Y, Legend( 11 ) ), Smoother( X, Y, Legend( 12 ) ) )
);

summary = gb << make into data table();

summary << save("C:\temp\test.xlsx")

Re: data table with images -> Excel

Phil_Kay — Mon, 06 Feb 2023 10:02:21 GMT

Hi @hogi ,

I think the answer is no. You lose a lot of additional information when you save a JMP data table to Excel format.

Are images in cells even possible in Excel? Even then, I don't think you would be able to use the images as labels or markers, which is where saving plots as images to the JMP table is really useful.

I think you will have to think about other ways to share the graphics with your colleagues. JMP Live would an option.

Sorry, I hope this helps.

Phil

Re: data table with images -> Excel

jthi — Mon, 06 Feb 2023 10:23:10 GMT

Web page can also be an option but it can get quite large depending on the images. Quick demo using Interactive HTML (but you can build it without interactive html also)

Names Default To Here(1);
dt = Open("$SAMPLE_DATA/Big Class.jmp");

gb = dt << Graph Builder(
	Variables(X(:weight), Y(:height), Group X(:age), Group Y(:sex)),
	Elements(Points(X, Y, Legend(11)), Smoother(X, Y, Legend(12)))
);

dt_images = gb << make into data table();
close(dt, no save);

nw = new window("test",
	dt_images << get as report
);

nw << Save Interactive HTML("$DOWNLOADS\test.html");
nw << close window;
Close(dt_images, no save);

//Web("$DOWNLOADS\test.html");

Re: data table with images -> Excel

hogi — Fri, 28 Jun 2024 18:54:15 GMT

@Phil_Kay wrote:
...
Are images in cells even possible in Excel?

-> Yes. Attached an Excel file with countries and flags. For what I need, it is sufficient.

Even then, I don't think you would be able to use the images as labels or markers, which is where saving plots as images to the JMP table is really useful.

use as labels or markers... is really useful: maybe "useful" but definitely not the only reason for images in data tables. Often users just use Make into data table() to get the graphs - and won't use them as markers.

JMP Live would an option.

-> hm, partially.
I don't think, other users would be able to edit the data table in JMP Live - which is where Excel is really useful.