Thank you so much! This helps a lot, with x, y, z written in different columns. Thank you!
-----Original Message-----
From: Guillaume Flandin [mailto:[log in to unmask]]
Sent: Thursday, February 25, 2010 11:59 AM
To: Huang, Wei (Psychiatry)
Cc: [log in to unmask]
Subject: Re: [SPM] Is there a way to save the table of statistics result?
Dear Wei,
once you've done right-click "Extract table data structure", you can run
something along those lines to save the results as an XLS document:
d = [ans.hdr;ans.dat];
xyz = d(3:end,end);
xyz = num2cell([xyz{:}]');
d(:,end+1) = d(:,end);
d(:,end+1) = d(:,end);
d(3:end,end-2:end) = xyz;
xlswrite('myresults.xls', d)
I hope this helps,
Guillaume.
Huang, Wei (Psychiatry) wrote:
> Dear All,
>
>
>
> Since my last email didn't get any response, I'm posting it again.
>
>
>
> Does anyone know how to export or save the Statistics table (with p
> values and coordinates, especially coordinates) of SPM results? I could
> have the table printed out in Matlab interface by right-click -> extract
> text table, but how do I save it, for example, as an excel file?
>
>
>
>
>
> Wei Huang, PhD
>
> Center for Comparative NeuroImaging (CCNI)
>
> Department of Psychiatry
>
> University of Massachusetts Medical School
>
> 55 Lake Ave North
>
> Worcester, MA 01604
>
> Tel: (508) 856 8261
>
> Fax: (508) 856 8090
>
>
>
--
Guillaume Flandin, PhD
Wellcome Trust Centre for Neuroimaging
University College London
12 Queen Square
London WC1N 3BG
|