saving data from how to save multiple data from Log Window into SEPARATE COLUMNS of one EXCEL sheet

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

saving data from how to save multiple data from Log Window into SEPARATE COLUMNS of one EXCEL sheet

MartaN.
Dear all

I analyze multiple images and my final data (columns of numbers) is printed in Log window. Currently the data from each image is saved every time in new excel file (after analysis of new image from the batch) so at the end the number of excel files containing my results is equal to the number of images:

        selectWindow("Log");
        saveAs("text", Inputpath+"results"+i+".xls");

However, I would like them to be saved in consecutive columns of the same excel file. Is it possible?

Another thing is that I would like to save the data as numbers and in present form it is saved so that Excel doesn't recognizes most of the data points as numbers (what is worse, it removes comma from numbers higher than 1). I tried this:

 selectWindow("Log");
        saveAs("measurements", Inputpath+"results"+i+".xls");

But then an error occurs saying

Log window is not a result table

Could anyone help me with that? I would be very grateful! Thanks in advance.