MATLAB: Writing Arrays from Matlab to Excel

arraycellcell arraysexcelmatrix arraymatrix manipulationprogramming

Hello, I know how to write matrix from matlab to excel. But what I can do if I need to write a set of matrices whose dimensions vary, that is: I have a matrix A (n, n) and then a matrix B (1, c) where 'n' and 'c' are variable, so therefore I can not write with xlswrite specifiying a range of cells because the size of the matrices are not always constant. I want to write matrix A and then B separated with a code by an empty cell.

Best Answer

Call xlswrite multiple times, first to write A, then to write B.

Related Solutions

MATLAB: Xlswrite not writing few entries

From

doc xlswrite
...
Input Arguments
...
A — Data to writematrix | cell array
Data to write, specified as a two-dimensional numeric or character array, or, if each cell
contains a single element, a cell array.
If A is a cell array containing something other than a scalar numeric or a string, 
then xlswrite silently leaves the corresponding cell in the spreadsheet empty.

It seems there must be that there's something not meeting that criterion in the cell array.

MATLAB: Writing Cell Arrays to Excel

% Look at this example

n=79;
v={'h1' 'h2' 'h3' 'h4';'a' 'b' rand(n,1) rand(n,1)} % Your cell array
h=v(1,:)
a=[v(2,1:2);repmat({[]},n-1,2)]
b=num2cell(cell2mat(v(2,3:4)))
vfinal=[h;[a b]]

% Then use xlswrite with vfinal

Best Answer

Related Solutions

MATLAB: Xlswrite not writing few entries

MATLAB: Writing Cell Arrays to Excel

Related Question