Need to write cell array with double and char string to excel
조회 수: 6 (최근 30일)
이전 댓글 표시
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
답변 (1개)
Image Analyst
2014년 2월 18일
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
Image Analyst
2014년 2월 18일
편집: Image Analyst
2014년 2월 18일
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?
참고 항목
카테고리
Help Center 및 File Exchange에서 Spreadsheets에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!