Re: extracting values from log file to excel

Posted by dpoburko on Apr 24, 2009; 4:52pm
URL: http://imagej.273.s1.nabble.com/extracting-values-from-log-file-to-excel-tp3692768p3692769.html

Hi Donny,

 Have you considered saving all of you data in rows of a text file in
ImageJ then simply import the file into Excel and use the transpose
function in Excel to swap rows for columns? This doesn't exactly address
the problem, but it would quite fast.

Cheers,
Damon

Donny George wrote:

> Hello All
>
> I am trying to write a macro so that i can extract specific values from the
> log file to an excel file. I did try to understand the macro
> CustomTabStatFromResults but guess its too much of info for me.
>
> The image sg0000.bmp
> is being processed. Kindly wait ...
> Initial-  Mean 154.7636, Min 30, Max246, STD9.3166
> Modified Min103, Max188
> Final details- Mean154.3191, Min 31, Max242, STD8.7668
> The image sg0001.bmp
> is being processed. Kindly wait ...
> Initial-  Mean 155.1983, Min 29, Max245, STD9.5013
> Modified Min103, Max188
> Final details- Mean154.7540, Min 31, Max242, STD8.9154
> The image sg0002.bmp
> is being processed. Kindly wait ...
> Initial-  Mean 155.5076, Min 30, Max245, STD8.9303
> Modified Min103, Max188
> Final details- Mean155.0632, Min 33, Max242, STD8.2322
>
>
> this is the info which i have to save on to an excel file, in different
> columns with file name, respective mean, min, max etc
>
> is there any macro already existing so that i could absorb some motivation
> from. kindly help
>
> thanks in advance
>  

--

Damon Poburko, PhD
Postdoctoral Research Fellow
Stanford University School of Medicine
Dept. of Molecular & Cellular Physiology
279 Campus Dr., Beckman B103, Stanford, CA 94305
Ph: 650 725 7564, fax: [phone]