How can I write N-dimensional numeric array into excel sheet?
2 次查看(过去 30 天)
显示 更早的评论
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 个评论
采纳的回答
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
2022-3-17
Ohh..yes, there is type error. A matrix cannot be written using writetable. You can use xlswrite. Edited the answer.
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!