createSpreadsheetFromData.m

function createSpreadsheetFromData(dataIn, header, filename)

% Copyright (C) 2013-2014 University of Dundee & Open Microscopy Environment.
% All rights reserved.
% 
% This program is free software; you can redistribute it and/or modify
% it under the terms of the GNU General Public License as published by
% the Free Software Foundation; either version 2 of the License, or
% (at your option) any later version.
% 
% This program is distributed in the hope that it will be useful,
% but WITHOUT ANY WARRANTY; without even the implied warranty of
% MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
% GNU General Public License for more details.
% 
% You should have received a copy of the GNU General Public License along
% with this program; if not, write to the Free Software Foundation, Inc.,
% 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.

[sizeY sizeX] = size(dataIn);
dimY = ones(sizeY,1);
dimX = ones(1,sizeX);
if ~iscell(dataIn)
    dataCell = mat2cell(dataIn, dimY, dimX);
else
    dataCell = dataIn;
end
dataCellOut = [header; dataCell];

xlswrite(filename, dataCellOut);