Borrar filtros
Borrar filtros

writing multiple 2D matrices in 1 excel file

3 visualizaciones (últimos 30 días)
Ananya Malik
Ananya Malik el 28 de Ag. de 2017
Editada: KL el 28 de Ag. de 2017
I have multiple variables containing 2D data that I want to write in either xls or txt file.
Suppose in each iteration I get A = [50x2], B=[10x2], C=[13x2], D=[11x2], E=[15x2], I want to write all this data in the same excel sheet. Is it possible. Any help appreciated. TIA.

Respuesta aceptada

KL
KL el 28 de Ag. de 2017
Editada: KL el 28 de Ag. de 2017
sheetA = 1;
sheetB = 2;
xlswrite(filename,A,sheetA)
xlswrite(filename,B,sheetB) %and so on

Más respuestas (1)

KSSV
KSSV el 28 de Ag. de 2017
A = rand(10,3) ;
B = rand(3,3) ;
dlmwrite('test.txt',A,'-append')
dlmwrite('test.txt',B,'-append')
  1 comentario
Ananya Malik
Ananya Malik el 28 de Ag. de 2017
Editada: Ananya Malik el 28 de Ag. de 2017
Thank you. This code appends everything without clear distinction. I would prefer the data to be in columns. Hence maybe excel sheet would be a better choice right?

Iniciar sesión para comentar.

Categorías

Más información sobre Data Import from MATLAB en Help Center y File Exchange.

Community Treasure Hunt

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

Start Hunting!

Translated by