How can I write N-dimensional numeric array into excel sheet?
2 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Waseem AL Aqqad
am 17 Mär. 2022
Kommentiert: Waseem AL Aqqad
am 17 Mär. 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 Kommentare
Akzeptierte Antwort
KSSV
am 17 Mär. 2022
Bearbeitet: KSSV
am 17 Mär. 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 Kommentare
KSSV
am 17 Mär. 2022
Ohh..yes, there is type error. A matrix cannot be written using writetable. You can use xlswrite. Edited the answer.
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!