Need to write cell array with double and char string to excel
2 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
I have a cell array where the first row is a string of characters identifying the information underneath and the rest of the rows are the numerical values.
A{1,:} = {'Year','Month','Day','Hour','Weekday','kW'}
A{2,:} = {2012,1,23,0.15,2,179}
Im trying to use xlswrite to write the cell array to an excel file. Turns out that Matlab doesn't like this. The error I get is "The input cell array cannot be converted to a matrix" . Anyone out there know of a work around to write my multi-type cell array to excel?
0 commentaires
Réponses (1)
Image Analyst
le 18 Fév 2014
Try this, using parentheses instead of braces:
A(1,:) = {'Year','Month','Day','Hour','Weekday','kW'}
A(2,:) = {2012,1,23,0.15,2,179}
xlswrite('text.xlsx', A);
2 commentaires
Image Analyst
le 18 Fév 2014
Modifié(e) : Image Analyst
le 18 Fév 2014
What are you expecting? I tried it and it does work . No errors at all. It puts each word into one Excel cell. The words in the top row, and the numbers into the second row. Exactly what were you hoping for?
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!