Login  Register

Re: how to append results in excel file

Posted by Martin Höhne on Oct 21, 2014; 9:08pm
URL: http://imagej.273.s1.nabble.com/how-to-append-results-in-excel-file-tp5002126p5010142.html

Hello everyone,

Since I stumbled over this older post while looking for a solution for the same problem, I thought I post the solution I figured out ...

Martin

---------------------------------------------------------------------------------
//deselect Results>Options>Results Table Options>Copy Column Headers
//in order to avoid multiple header lines in the combined Results table

run("Blobs (25K)");
run("Invert");
setAutoThreshold("Default dark");
setOption("BlackBackground", true);
run("Convert to Mask");

table="[Combined Results]";
run("Table...", "name="+table+" width=450 height=500");

results_merge=""; //variable that will be filled with all results

for (i=0; i<3; i++) {
        run("Analyze Particles...", "size=2-infinity display exclude clear");
        String.copyResults;
        resultati=String.paste;  
        results_merge=results_merge+resultati;

        selectWindow("Results"); //to save the Results of each individual run
        //saveAs("Text",..........");
}

print(table,String.getResultsHeadings);
print(table,results_merge); //this table contains all results
---------------------------------------------------------------------------------------