How can I write N-dimensional numeric array into excel sheet?

2 visualizzazioni (ultimi 30 giorni)
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!

Risposta accettata

KSSV
KSSV il 17 Mar 2022
Modificato: KSSV il 17 Mar 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 Commenti
KSSV
KSSV il 17 Mar 2022
Ohh..yes, there is type error. A matrix cannot be written using writetable. You can use xlswrite. Edited the answer.

Accedi per commentare.

Più risposte (0)

Community Treasure Hunt

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

Start Hunting!

Translated by