How to write data array as excel file (keeping column orientation)
显示 更早的评论
I have 2 variables each contain numerica data (501X1double). I want to combine each column and extract as excel file keeping the column orientation, how to do this best?
First: I create Table: T=array2table({A,B},'VariableNames',{'A','B'})
Then: I write Table: writetable(T,'exceloutput.xlsx')
Problem: data is row oriented, i.e. all data is in first first row of excel sheet.
How to keep the column orientation?
采纳的回答
Mrunmayee Gaikwad
2020-9-21
0 个投票
In the line:
T=array2table({A,B},'VariableNames',{'A','B'})
the use of curly braces in combining two arrays {A,B}, would return a 1x2 cell array and not a numeric matrix. This caused the table to contain all the data in a single row.
To get a numeric matrix from combining the arrays use square braces instead of curly braces like:
T=array2table([A,B],'VariableNames',{'A','B'})
For more information on combining matrices see the following link:
更多回答（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 
