how to export cell array to excel

5 views (last 30 days)
My code generates a cell array with five (5x5) num cells and now I need to export it in a way that each cell of the array will be written in a different sheet of an excel file.
Actually if I use xlswrite, an empty xls file is generated.
I apologize for the silly question but I am a new matlab user and I have not found any useful information in the community
Thanks in advance
Davide

Accepted Answer

KALYAN ACHARJYA
KALYAN ACHARJYA on 15 Dec 2020
Lets say "cell_data" is cell array
[r c]=size(cell_data);
sheet_num=1;
for i=1:r
for j=1:c
data=cell_data{i,j};
xlswrite('cell_data.xlsx',data,['Sheet',num2str(sheet_num)]);
sheet_num=sheet_num+1;
end
end

More Answers (0)

Products


Release

R2020b

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!