Send results to Excel

[nmichel]

Hello,

I was wondering if it is possible to send the results log, after using  
analyze particles for example, to another word processing or  
spreadsheet program, such as excel or word, for further processing and  
which function does that?

Thanks,
Nicholas

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

[ctrueden]

Hi Nicholas,

> I was wondering if it is possible to send the results log, after using
> analyze particles for example, to another word processing or
> spreadsheet program, such as excel or word, for further processing and
> which function does that?

With the Results Table window active, choose File > Save As to export the
data to a text file.

You can then open that text file in a spreadsheet program such as Excel or
OpenOffice Calc as a table.

-Curtis


On Fri, Oct 12, 2012 at 8:20 AM, Nikolaos Michelarakis
<[hidden email]>wrote:

> Hello,
>
> I was wondering if it is possible to send the results log, after using
> analyze particles for example, to another word processing or spreadsheet
> program, such as excel or word, for further processing and which function
> does that?
>
> Thanks,
> Nicholas
>
> --
> ImageJ mailing list: http://imagej.nih.gov/ij/list.**html<http://imagej.nih.gov/ij/list.html>
>

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

[vischer]

> On 12. Oct 2012, at 15:20, Nikolaos Michelarakis wrote:
>
> Hello,
>
> I was wondering if it is possible to send the results log, after using analyze particles for example, to another word processing or spreadsheet program, such as excel or word, for further processing and which function does that?

Hello Nikolaos

this is documented here:
http://rsbweb.nih.gov/ij/macros/ExecExamples.txt

I also used these methods years ago, and Excel immediately locked that file, so ImageJ could not overwrite it with a newer version. Meanwhile, Excel behaves better: re-running the macro updates the existing Excel document (good to know!).

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

[nmichel]

Thank you very much, just one last question, would it be possible to  
have a dialog box with a variable, let's say save_path for example,  
where the user would type or select the path and the file would be  
saved there? What I mean is, could the path be used as a variable?

Nicholas

----- Message from [hidden email] ---------
     Date: Fri, 12 Oct 2012 18:21:16 +0200
     From: Norbert Vischer <[hidden email]>
Reply-To: [hidden email]
  Subject: Re: Send results to Excel
       To: [hidden email]

>> On 12. Oct 2012, at 15:20, Nikolaos Michelarakis wrote:
>>
>> Hello,
>>
>> I was wondering if it is possible to send the results log, after  
>> using analyze particles for example, to another word processing or  
>> spreadsheet program, such as excel or word, for further processing  
>> and which function does that?
>
> Hello Nikolaos
>
> this is documented here:
> http://rsbweb.nih.gov/ij/macros/ExecExamples.txt
>
> I also used these methods years ago, and Excel immediately locked  
> that file, so ImageJ could not overwrite it with a newer version.  
> Meanwhile, Excel behaves better: re-running the macro updates the  
> existing Excel document (good to know!).
>
> Norbert Vischer
> --
> ImageJ mailing list: http://imagej.nih.gov/ij/list.html
>

----- End message from [hidden email] -----

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

[vischer]

> On 12. Oct 2012, at 19:31, Nikolaos Michelarakis wrote:
>
> Thank you very much, just one last question, would it be possible to have a dialog box with a variable, let's say save_path for example, where the user would type or select the path and the file would be saved there? What I mean is, could the path be used as a variable?
>

Just play with Plugins>Macros>Record…

then do things manually and look what code is generated. And check
        http://imagej.nih.gov/ij/macros/FileDemo.txt
for documetation.
For example
        saveAs("Results", "");
will try to use the second argument as path, or in this case present a dialog for user input.

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