Why doesn't xlswrite work properly for this code
2 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
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 commentaire
Jan
le 13 Oct 2011
At leat I get an error message, when I try to run XLSWRITE with this cell as input.
Réponse acceptée
Artik Crazy
le 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');
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Spreadsheets dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!