a big cell array

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?

Answer 1

[dpb]

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.

[Hussein Ayoub]

RunActivityData_mat=cell2mat(RunActivityData);  11*1000   single element cell

i have tried this code ,i want to write every column to excel sheet.

for Write_data=1:size(RunActivityData_mat,2);
   WrittienDurations= RunActivityData_mat(:,Write_data);
   myfilename = sprintf('file%d.xlsx', Write_data);
   xlswrite(myfilename, WrittienDurations,'TASK','B1:B11');
    end

it is done .

but it is not good because there is a huge number of excel sheets ,i try to fit this problem

[dpb]

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.