Re: Writing results and embedding images into spreadsheet cells
Posted by
Justin McGrath on
Jan 30, 2008; 3:17pm
URL: http://imagej.273.s1.nabble.com/Writing-results-and-embedding-images-into-spreadsheet-cells-tp3697333p3697338.html
It's possible to insert pictures into Excel, but I'm almost positive
it's not possible to put them into cells. Instead they float over the
spreadsheet. I don't know how you could insert the pictures into
Excel using ImageJ.
I use an SQL database and a php page to display my data alongside the
pictures, but it requires a couple of scripts to get things into the
database. You could use the same setup, but if you don't really need
a database, then an easier way might be to have ImageJ output the
results in HTML and include the images via the img tag. Since you can
write your own file directly in ImageJ, it should be fairly easy.
Justin
On Jan 18, 2008 7:03 AM, Andy Weller <
[hidden email]> wrote:
> Dear all,
>
> I have a macro that writes several results and info to a separate
> Results.txt file. Effectively, it is:
>
> dir = getDirectory("Choose Directory");
> f = File.open(dir + "Results.txt"); // Open results file
> .
> out = fileName + "\t" + a + "\t" + b;
> print(f, out + "\n");
>
> What would be interesting is when I open Results.txt in a spreadsheet
> package, the cells in the first column would have the images embedding
> into them. I can then check out my results in relation to the images.
>
> Do you know if this is possible? I know you can do hyperlinks, but I
> would really like to 'see' the images alongside the measurements, in the
> same window.
>
> If it is, what would be the format of the "fileName" (or "image1.tif")
> above (considering that Results.txt is stored in the same folder as the
> images).
>
> Thanks, Andy
>