a big cell array
1 view (last 30 days)
Show older comments
if i have a cell array 11*1000 elements,and i want to write every each one column vector from the 1000 columns to an excel sheet or file in one command what do i have to?
0 Comments
Answers (1)
dpb
on 9 Aug 2019
Edited: dpb
on 10 Aug 2019
Follow the documentation--for xlswrite, every cell element has to be a single value. So, if your array has cells (or any single cell) containing more than one element per each, you've got to expand it first.
W/ R2019a, TMW has introduced writecell and deprecated xlswrite I don't have the release so can't test but same caveat on cell array content is implied albeit not explicitly stated and it says uses '%g' as a format so may not reproduce data as does xlswrite.
2 Comments
dpb
on 10 Aug 2019
Just write the array...RunActivityData_mat is an array, just write it instead making up eleven files.
xlswrite(myfilename, cell2mat(RunActivityData),'TASK','B1');
is all you need other than to create a meaningful filename.
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!