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

1 view (last 30 days)
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!

Accepted Answer

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

Sign in to comment.

More Answers (0)

Community Treasure Hunt

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

Start Hunting!