Export cell array into Excel
显示 更早的评论
Hello All,
I have been asked to quickly put together a data extraction tool for some data being collected for a research project. The data has been exported into a 36x1 cell (data_1) which comprises of 36 14x1 double vectors.
I have been asked that this data is exported onto one excel sheet. From what I have read I need to take the cell array data_1 and turn it into one 14x36 cell array.
Below is that code that I have been working with along with a screenshoot of the current output. As you can see there are 36 cells which are not correct however the rest of the data in the cell is correct.
What am I doing wrong?
Many thanks in advance
for ii = 1:length(Trials)
data_1_extraction = data_1{ii,1}; % Extract first cell.
ca{ii} = cell(14,length(Trials));
for row = 1 : size(data_1_extraction, 1)
ca{row,ii} = data_1_extraction(row);
end
end
采纳的回答
dpb
2019-3-26
C=num2cell(cell2mat(data_1.'));
xlswrite(file,C,sheet,range)
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
