MATLAB: Writing data of different length to Excel

cell arrayexcelxlswrite

Hi I'm trying to write different length of data (all floats) to Excel but can't make it work…

a short example for simplicity:

a = 1:3;
b = 1:4;

and try to write both of them in one-shot to the same spreadsheet. Have tried to use 'num2cell()' without success.

Thanks in advance for the helpers

Best Answer

Did you try xlswrite()?

xlswrite(filename, a, 'A1');
xlswrite(filename, b, 'A2');

With MATLAB version R2015b and later there is virtually no speed penalty doing it in two calls instead of 1.

Related Solutions

MATLAB: I have data in the same excel workbook but in 10 different work sheets and i’m trying to run a loop that will read in the data from each work sheet consectutively.

You could use xlsread along with xlsinfo.

 [status,sheets] = xlsfinfo(filename);

Now, you have all the sheet names under sheets and you loop through that.

 data = cell(numel(sheet),1); %pre-allocate your variable
 for sheetNo = 1:numel(sheet)
    data(sheetNo,1) = xlsread(filename,sheets{sheetNo},Range);
    ...
 end

Goodluck!

MATLAB: Can you help me how to extract a matrix of image and put it in Excel. more precisely how individual color, R G B this matrix to extract and put it in excel

Try this:

% Extract the individual red, green, and blue color channels.
redChannel = rgbImage(:, :, 1);
greenChannel = rgbImage(:, :, 2);
blueChannel = rgbImage(:, :, 3);
% Write out to separate sheets in an Excel workbook.
xlswrite(filename, redChannel, 'Red', 'A1');
xlswrite(filename, greenChannel, 'Green', 'A1');
xlswrite(filename, blueChannel, 'Blue', 'A1');

Best Answer

Related Solutions

MATLAB: I have data in the same excel workbook but in 10 different work sheets and i’m trying to run a loop that will read in the data from each work sheet consectutively.

MATLAB: Can you help me how to extract a matrix of image and put it in Excel. more precisely how individual color, R G B this matrix to extract and put it in excel

Related Question