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

Question

wd8555 2020-9-17

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/595546-how-to-write-data-array-as-excel-file-keeping-column-orientation

评论： wd8555 2020-10-1

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?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Mrunmayee Gaikwad 2020-9-21

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/595546-how-to-write-data-array-as-excel-file-keeping-column-orientation#answer_497812

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