Writing results and embedding images into database

Posted by Andy Weller on Jan 31, 2008; 10:54am
URL: http://imagej.273.s1.nabble.com/Writing-results-and-embedding-images-into-spreadsheet-cells-tp3697333p3697334.html

What we are after here is a means by which we can save all our data from
a macro (image and results) into some kind of format that makes it easy
to subsequently view.

At present we view our resultant images separately from the results,
which are viewed in a spreadsheet.

We would like to amalgamate these.  (My guess is that we should output
to a format recognisable by some database.)

Does anyone output their results/images into a database format of some
kind, allowing them to view all their data 'together'?

Is this possible?

Some help/pointers would be greatly appreciated.

Thanks, Andy

Andy Weller 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