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)
