What seems to work for me with SPM5 and Matlab 7, is right click on the
table, "print text table". Then the table appears on the Matlab command
window. Whatever is there can be selected (using the mouse with left button
pressed down), copied and pasted onto excel.
Gerry
=================================
Dr G Markopoulos ([log in to unmask])
Department of Neurology
Zenit 1 Building
Faculty of Medicine
Otto-von-Guericke University
Leipziger Straße 44
39120 Magdeburg
Germany
Tel: 0049 391 6117543 Fax: 0049 391 6117531
-----Original Message-----
From: SPM (Statistical Parametric Mapping) [mailto:[log in to unmask]] On
Behalf Of Guillaume Flandin
Sent: Donnerstag, 25. Februar 2010 17:59
To: [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
|