Why doesn't xlswrite work properly for this code

2 次查看（过去 30 天）
Injectors
Injectors 2011-10-13
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 个评论
Jan
Jan 2011-10-13
At leat I get an error message, when I try to run XLSWRITE with this cell as input.

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

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

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by