Save as Excel sheet a matlab variable which contains many other variables and cell arrays

Hi Everyone,

I have a problem as to how I may save a cell array which is contained inside a variable as an excel sheet. I have attached a screen shot. The "ma" is the variable, and I would like to save the cell array "msd" as an excel sheet. Would be great if someone could help me with this, as it is quite complicated for me as this case is a cell array inside another variable... I am looking at both options where I save the cell array as an excel sheet with several tabs (each tab containing each cell data) and the other situation where the excel sheet will have only one sheet, where the cell information will be stored as consecutive sets of columns, one after the other. I don't really know if this is possible...? (Matlab version R2015a)

Thank you in advance!

Best Sara

Answer 1

[KSSV]

Writes one matrix/ cell in different sheets:

N = 5 ;
A = cell(N,1) ;
for i = 1:N
    A{i} = rand(2,3) ;
end

for i = 1:N
    xlswrite('check.xlsx',A{i},i)
end

Writes matrix into one sheet, with space between each cell.

N = 5 ;
A = cell(N,1) ;
for i = 1:N
    A{i} = rand(2,3) ;
end
B = A ;
[m,n] = size(A{1}) ;
A = cell2mat(A) ;

pos = m+1:m+1:m+(N+1)*m ;
[r,c]       = size(A);
add         = numel(pos);            % How much longer Anew is
Anew        = NaN(r + add,c);        % Preallocate
idx         = setdiff(1:r+add,pos);  % all positions of Anew except pos
Anew(idx,:) = A;

xlswrite('check.xlsx',Anew)

[SNT]

Hi KSSV,

Thanks a lot! This works well for cell arrays on their own.. but in my case the cell array is contained inside a another variable (looks like a cube shape). And by simply doing;

for i = 1:100
    xlswrite('blabla.xlsx',msd{i},i)
end

I get below error...

Undefined variable "msd" or class "msd".

How can I access this cube shaped variable and then write the msd cell array? I have attached a screen shot of this ma (cube shaped) variable. I have no idea what this variable is called..

Thanks a lot in advance! Sara

[Stephen23]

msd is not a variable in that workspace, it is the field of a structure. You need to tell MATLAB that:

 xlswrite('blabla.xlsx',ma.msd{i},i)
                         ^^^ You need the structure!

https://www.mathworks.com/help/matlab/matlab_prog/access-data-in-a-structure-array.html

[SNT]

Hi Stephen,

Thanks a lot for your help. It works beautifully now!

Sara

[SNT]

Hi KSSV,

When I tried the second approach, of saving I get an error at this line. Have I made an error?

Anew(idx,:) = A;
Subscripted assignment dimension mismatch.

Thanks a lot! Sara

[SNT]

This is the whole code I put on matlab

N=100;
[m,n] = size(ma.msd {1}) ;
A = cell2mat(ma.msd) ;
pos = m+1:m+1:m+(N+1)*m ;
[r,c]       = size(ma.msd);
add         = numel(pos);            % How much longer Anew is
Anew        = NaN(r + add,c);        % Preallocate
idx         = setdiff(1:r+add,pos);  % all positions of Anew except pos
Anew(idx,:) = A;
xlswrite('check.xlsx',Anew)

Thanks!