Why doesn't xlswrite work properly for this code

1 view (last 30 days)
output_data = {t,y,A};
xlswrite('testdata_output.xlsx',output_data)
Variables
t = 500 * 1 Matrix
y = 500 * 1 Matrix
A = [0.997250595282513;4.028650036049457;4.966927941572196]
For some reason when I run it does not display anything in the excel file. Could someone help me fix it. Thanks
  1 Comment
Jan
Jan on 13 Oct 2011
At leat I get an error message, when I try to run XLSWRITE with this cell as input.

Sign in to comment.

Accepted Answer

Artik Crazy
Artik Crazy on 13 Oct 2011
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');

More Answers (0)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!