a big cell array
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
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 Kommentare
Antworten (1)
dpb
am 9 Aug. 2019
Bearbeitet: dpb
am 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 Kommentare
dpb
am 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.
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!