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

2022 3 17
1 个回答
回答已采纳
更新时间：2022 3 17
5 次查看（30 天）

0 个投票

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

0 个投票

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 个评论
显示 1更早的评论 隐藏 1更早的评论

Waseem AL Aqqad
Waseem AL Aqqad 2022-3-17
Thank you so much. I was referring to the third dimension, I thought it's called a page (r- by c- by p).
I'm using MATLAB 2018a, so write2table is not a defined function. I tried using writetable but I got an error of "Undefined function 'write' for input arguments of type 'double'."
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 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by