Dear Wei Huang,
I'm not aware of a way to get this immediately into XL.
But after pressing eg the 'whole brain' button (or extract table data
structure) the table data will be written to ans.dat in the matlab
workspace.
You could then type eg.
> R=ans;
> C=[R.dat{:,12}]';
> save coords C -ascii
This will save the x,y,z, coordinates to a text file called coords which
you can then load into XL.
BEst, Will.
PS. You could then do same for z scores eg.
> Z=[R.dat{:,10}]';
> save Zstats Z -ascii
Huang, Wei (Psychiatry) wrote:
> Dear SPMers,
>
>
>
> 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?
>
>
>
> Thank you,
>
>
>
>
>
> 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
>
>
>
--
William D. Penny
Wellcome Trust Centre for Neuroimaging
University College London
12 Queen Square
London WC1N 3BG
Tel: 020 7833 7475
FAX: 020 7813 1420
Email: [log in to unmask]
URL: http://www.fil.ion.ucl.ac.uk/~wpenny/
|