MATLAB: Exporting cell arrays with different sizes to excel

cell arrayexport

I have a cell array A with size [1×2], which contains two different arrays [1×4 double] and [1×5 double]. I need to have the different arrays in A in Excel, with the first array on A1 and the second array on A2. However, the only thing I managed to get is to get both arrays behind each other in A1, using B=cell2mat(A), and then xlswrite(filename,B).

How do I get the first array on A1 and the second array on A2?

Thanks in advance!

Best Answer

Do this:

xlswrite(filename,A{1},'1','A1');
xlswrite(filename,A{2},'1','A2');

Related Solutions

MATLAB: Doesn’t xlswrite work properly for this code

From xlswrite help:

xlswrite(filename,A)
Input Arguments:
A
Two-dimensional numeric or character array or, if each cell contains a single element, a cell array.

For example xlswrite('testdata_output.xlsx',{t}) won't work as well, because the cell contains a 500x1 matrix and not a single element.

xlswrite('testdata_output.xlsx',{1}) works good.

Try this instead:

xlswrite ('testdata_output.xlsx', [t y], 1, 'A1');
xlswrite ('testdata_output.xlsx', A, 1, 'C1');

MATLAB: Write cell arrays to matlab

for K = 1 : length(A)
  thissheetname = sprintf('Sheet#%02d', K);
  xlswrite('YourFile.xls', A{K}, thissheetname);
end

Best Answer

Related Solutions

MATLAB: Doesn’t xlswrite work properly for this code

MATLAB: Write cell arrays to matlab

Related Question