Login  Register

automating sending batch processing summary to excel

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options Options
Embed post
Permalink
Reply | Threaded
Open this post in threaded view
| More
Print post
Permalink

automating sending batch processing summary to excel

cfost
1 post
Hi,

I know that a summary from batch processing can be saved as an Excel file. However, I'm wondering if it's possible or if anyone has written code to make this process automatic? i.e. as soon as a new summary is created from batch processing in ImageJ, can Excel know to open it?

My end goal is for images to be opened in ImageJ, processed, and the results auto-emailed. (I know VBA can be used with Excel to send emails).

I realize this might be platform-dependent -- I'm mainly working on a Mac, have Word for Mac, but I can also run a pc virtual machine.

Thanks.
Reply | Threaded
Open this post in threaded view
| More
Print post
Permalink

Re: automating sending batch processing summary to excel

Pariksheet Nanda
50 posts
On Fri, Jun 21, 2013 at 2:54 PM, cfost <[hidden email]> wrote:
> as soon as a new summary is created from
> batch processing in ImageJ, can Excel know to open it?
>
> My end goal is for images to be opened in ImageJ, processed, and the results
> auto-emailed. (I know VBA can be used with Excel to send emails).
>
> I'm mainly working on a Mac
>

You can do this with a macro, though you would have to both, run the
command that does the batch processing for you, and save the Results
Table file.  To save the Results Table use:

    selectWindow("Results");
    saveAs("results", "/path/to/save.txt");

To send the e-mail, use the exec() macro command.  Here are some examples:
http://imagej.nih.gov/ij/macros/ExecExamples.txt

This article describes how to  send an e-mail using Outlook from the
command line (though I think it only applies to Windows; hopefully the
Mac equivalent is similar enough)
http://support.microsoft.com/kb/192341

I don't see a way to attach the data, so what you could do instead is
store the Results Table as a string in a variable and set that
variable to to be the e-mail body in the exec() command.

--
ImageJ mailing list: http://imagej.nih.gov/ij/list.html