saving 3 dimensional single data in an Excel file

Hello all

I have three dimensional epoched data (EEG data, 32*300*14 single ( channels x time points x trials) and I need to save the data in an excel file. However based on the error I got using xlswrite function, it seems that Excel handles only two dimensional data. . How can I save this 3 dimentional data (as 2 dimential i suppose) in an excel file? .

Thank you very much

Zahra

Answer 1

[Bob Thompson]

xlswrite is only able to write data in a 2D format because it can only write to one sheet at a time. In order to write your 3D data you can either reshape the data into a large 2D array, or you can run a loop to save each sheet of your data to a sheet of the excel file.

% Credit to cyclist for this
C = permute(A,[1 3 2]);
C = reshape(C,[],size(A,2),1)

% Or the loop
for i = 1:size(A,3)
    xlswrite('myexcelout.xlsx',A,i)
end

[Elaheh]

Thank you so much for your reply. The excel file was created but there is an issue. My orignial data is EEG (32*300*14), 32 is the number of channels (the EEG cap electords) that I have. In the excel file, I need each channel to occupy one row so that I have the data for each channel in front of it. The resulted file is 448*330. I do not know how the data is arranged.

[Bob Thompson]

32*14 = 448. The data is organized such that each former sheet has been moved to the tail end of the first page. Therefore, the first 32 rows are the first sheet, the second 32 rows (33 to 64) are the second sheet, and so on.

I do not know where the extra 30 columns came from.

Answer 2

[Fangjun Jiang]

write each page to each sheet

for k=1:size(data,3)
xlswrite('Book1.xlsx',data(:,:,k),k)
end

This will run xlswrite() k times so it's not most efficient.

You could use Write Data to Excel Spreadsheet Using ActiveX