Need to write cell array with double and char string to excel
2 views (last 30 days)
Show older comments
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 Comments
Answers (1)
Image Analyst
on 18 Feb 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 Comments
Image Analyst
on 18 Feb 2014
Edited: Image Analyst
on 18 Feb 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?
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!