Write nested cell array data into separate excel sheets

13 views (last 30 days)
Ganesh Naik
Ganesh Naik on 18 Mar 2022
Commented: Arif Hoq on 18 Mar 2022
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)

Community Treasure Hunt

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

Start Hunting!

Translated by