Write nested cell array data into separate excel sheets

23 views (last 30 days)
Hi all,
I have a nested array data (5 rows and 7 columns) and would like to save the results of each row onto separate excel sheets. In my case, I have 5 rows of nested cell data where I would like to have 5 excel sheets with sheet names representing the ID of the user.
Any help in this is highly appreciated. I have attached the data.

Accepted Answer

Arif Hoq
Arif Hoq on 18 Mar 2022
Edited: Arif Hoq on 18 Mar 2022
try this:
A=load('Data3.mat');
B=A.Tc ;
firstrow=[B{1,:}];
% C=string(firstrow);
writecell(firstrow,'filename1.xlsx')
secrow=[B{2,:}];
writecell(secrow,'filename2.xlsx')
thirdrow=[B{3,:}];
writecell(thirdrow,'filename3.xlsx')
upto row 5....
  3 Comments

Sign in to comment.

More Answers (0)

Categories

Find more on Data Import from MATLAB 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!

Translated by