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

1 回表示 (過去 30 日間)
Waseem AL Aqqad
Waseem AL Aqqad 2022 年 3 月 17 日
コメント済み: Waseem AL Aqqad 2022 年 3 月 17 日
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!

採用された回答

KSSV
KSSV 2022 年 3 月 17 日
編集済み: KSSV 2022 年 3 月 17 日
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 件のコメント
KSSV
KSSV 2022 年 3 月 17 日
Ohh..yes, there is type error. A matrix cannot be written using writetable. You can use xlswrite. Edited the answer.
Waseem AL Aqqad
Waseem AL Aqqad 2022 年 3 月 17 日
It works now. Thanks again bro.
Much appreciated.

サインインしてコメントする。

その他の回答 (0 件)

カテゴリ

Help Center および File ExchangeSpreadsheets についてさらに検索

Community Treasure Hunt

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

Start Hunting!

Translated by