Re: how to append results in excel file

Posted by Brandon Hurr on Aug 02, 2017; 2:47am
URL: http://imagej.273.s1.nabble.com/how-to-append-results-in-excel-file-tp5002126p5019150.html

Depends how you're doing your analysis.

If you're looping through pictures in a folder then you should create a
results table and print to that in every iteration. I typically save the
results table to a file every loop too in case of problems. You can just
overwrite this every iteration rather than append (writing a csv file is
not that time consuming unless the file is huge).

If you're doing something else... you'll have to spell that out and help us
help you (and others).

How to make a custom results table and record to it:
http://imagej.1557.x6.nabble.com/How-to-create-a-customised-results-table-and-add-data-to-it-within-a-macro-td5000701.html
Save that file out as csv (txt):
http://imagej.1557.x6.nabble.com/save-results-table-as-csv-with-custom-name-td5003427.html

Put that into a loop and you're golden.

B

On Tue, Aug 1, 2017 at 7:15 PM, Guy Lyons <[hidden email]> wrote:

> I am trying to do exactly what Annie Venien described in the original post
> using ImageJ macro language i.e. save analysis data from images into
> individual files AND also combine them into a single csv file. Tried all
> sorts of things involving strings, File.append, etc., to combine them into
> a
> single csv file, but can't crack it. A lot of people have requested advice
> for the same thing in various forums. The "Read and Write Excel" plugin
> adds
> data side-by-side, instead of appending it in columns. Has anyone come up
> with a plugin or other method to achieve this, either as you go during
> analysis of multiple files, or post-analysis to concatenate csv data files
> vertically?
>
>
>
> --
> View this message in context: http://imagej.1557.x6.nabble.
> com/how-to-append-results-in-excel-file-tp5002126p5019149.html
> Sent from the ImageJ mailing list archive at Nabble.com.
>
> --
> ImageJ mailing list: http://imagej.nih.gov/ij/list.html
>

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