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

9 次查看（过去 30 天）
wd8555
wd8555 2020-9-17
评论： 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?

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

采纳的回答

Mrunmayee Gaikwad
Mrunmayee Gaikwad 2020-9-21
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

更多回答（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!

Translated by