Conversion of arrays to cell array
1 次查看(过去 30 天)
显示 更早的评论
I have time series data as a pivot in an array.
The first row and first column are headers.
x =
NaN 101 102 103 104
731034 4 3 NaN 3
731035 5 NaN 2 1
731036 6 2 5 2
731037 3 1 4 7
I would like to write the above data into an excel but the first column needs to be dates and not datenum. I tried to create a cell array contaning datestr and other columns and then write it to an excel, but I get an error saying "Element of an array cannot be a character matrix" when data is being written to the excel.
采纳的回答
Azzi Abdelmalek
2013-1-9
编辑:Azzi Abdelmalek
2013-1-9
x={'datenum' 'col1' 'col2' 'col3' 'col4'
731034 4 3 NaN 3
731035 5 NaN 2 1
731036 6 2 5 2
731037 3 1 4 7}
x(2:end,1)=cellstr(datestr(cell2mat(x(2:end,1))))
2 个评论
Azzi Abdelmalek
2013-1-9
编辑:Azzi Abdelmalek
2013-1-9
I don't know if you are working with cell or double array
x = [NaN 101 102 103 104
731034 4 3 NaN 3
731035 5 NaN 2 1
731036 6 2 5 2
731037 3 1 4 7]
out=num2cell(x)
idx=find(~isnan(x(:,1)))
out(idx,1)=cellstr(datestr(x(idx,1)))
更多回答(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!