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?

Answer 1

[Mrunmayee Gaikwad]

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:

https://www.mathworks.com/help/matlab/math/creating-and-concatenating-matrices.html

[wd8555]

Thank you!