Borrar filtros
Borrar filtros

Write nested cell array data into separate excel sheets

6 visualizaciones (últimos 30 días)
Ganesh Naik
Ganesh Naik el 18 de Mzo. de 2022
Comentada: Arif Hoq el 18 de Mzo. de 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.

Respuesta aceptada

Arif Hoq
Arif Hoq el 18 de Mzo. de 2022
Editada: Arif Hoq el 18 de Mzo. de 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 comentarios
Ganesh Naik
Ganesh Naik el 18 de Mzo. de 2022
I have figured out the answer. I am posting the detailed answer, Hope it is helpful to others.
If "Tc" is the nested cell array (refer to the Figure) then the following code creates separate Excel files for each nested row.
for i=1:numel(Tc(:,1))
Row= [Tc{i,:}]
writecell(Row,['filename' num2str(i) '.xlsx'])
end

Iniciar sesión para comentar.

Más respuestas (0)

Productos

Community Treasure Hunt

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

Start Hunting!

Translated by