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