How can I write N-dimensional numeric array into excel sheet?
2 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Waseem AL Aqqad
el 17 de Mzo. de 2022
Comentada: Waseem AL Aqqad
el 17 de Mzo. de 2022
I have a 1x120x289 numeric array (attached) that I want to write the different 289 pages into 289 different colomns in one excel sheet. Your help is appreciated.
Thanks!
0 comentarios
Respuesta aceptada
KSSV
el 17 de Mzo. de 2022
Editada: KSSV
el 17 de Mzo. de 2022
Why you want to write it in different pages? You can write in a single sheet; so that it woul dbe easy while reading. LEt A be your 1X120X289 data array.
A = squeeze(A) ; % this will change 1X120X289 to 120X289
xlswrite('test.xlsx',A) ; % write data to excel file
% REad the file
A = readmatrix('test.xlsx') ; % your A would be 120x289, you can access each column now
3 comentarios
KSSV
el 17 de Mzo. de 2022
Ohh..yes, there is type error. A matrix cannot be written using writetable. You can use xlswrite. Edited the answer.
Más respuestas (0)
Ver también
Categorías
Más información sobre Spreadsheets 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!