MATLAB Answers

How to write data array as excel file (keeping column orientation)

1 view (last 30 days)
wd8555
wd8555 on 17 Sep 2020
Commented: wd8555 on 1 Oct 2020
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?

Accepted Answer

Mrunmayee Gaikwad
Mrunmayee Gaikwad on 21 Sep 2020
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:

More Answers (0)

Community Treasure Hunt

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

Start Hunting!