[Eeglablist] write in excel

[Makoto Miyakoshi]

Dear Zahra and Zoran,

I uploaded a working Matlab code here for you.
https://sccn.ucsd.edu/wiki/Makoto%27s_useful_EEGLAB_code#How_to_export_data_to_an_Excel_file_.2808.2F09.2F2020_added.2C_prayer_to_Nagasaki.29

Makoto

On Sun, Aug 9, 2020 at 9:42 AM Makoto Miyakoshi <mmiyakoshi at ucsd.edu> wrote:

> > convert eeg data to excel file for other stats
>
> writetable('saveName.xlsx', array2table(EEG.data'), 'writevariablename',
> false, 'writerowname', false)
>
> alternatively,
>
> writetable('saveName', array2table(EEG.data'), 'writevariablename', false,
> 'writerowname', false, 'FileType', 'spreadsheet')
>
> If you use .xlsx it automatically uses  'FileType', 'spreadsheet'. This is
> described in 'help writetable'.
>
> Makoto
>
>
> On Thu, Aug 6, 2020 at 3:55 PM Makoto Miyakoshi <mmiyakoshi at ucsd.edu>
> wrote:
>
>> Dear Zahra,
>>
>> writetable(array2table(EEG.data'), 'writevariablename', false,
>> 'writerowname', false)
>>
>> Makoto
>>
>> On Wed, Aug 5, 2020 at 1:39 AM zahra fotovatnia <fotovatnia at yahoo.com>
>> wrote:
>>
>>> Hello all,
>>> Does anyone know how I can write my eegdata into an excel file (or
>>> SPSS)? I tried (writetable(struct2table(EEG.data), 'eegdata.xlsx')  but I
>>> got this error "Input structure must be a scalar structure, or a structure
>>> array with one column or one row.".  I need channel labels as well.
>>>
>>>
>>> I appreciate your help in advance.Zahra
>>> _______________________________________________
>>> Eeglablist page: http://sccn.ucsd.edu/eeglab/eeglabmail.html
>>> To unsubscribe, send an empty email to
>>> eeglablist-unsubscribe at sccn.ucsd.edu
>>> For digest mode, send an email with the subject "set digest mime" to
>>> eeglablist-request at sccn.ucsd.edu
>>
>>