How to write data to an excel file?

Question

VR 2019-5-1

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/459666-how-to-write-data-to-an-excel-file

评论： Star Strider 2019-5-1

In the process of learning how to write data to an excel file, I learnt that I should first write it as a table. So I gave it a try but what my code does is write two row vectors as one long row vector. I wanted to write two variables as two separate rows. Here is my attempt:

(My final goal is to save my workspace data to an excel file.)

data1 = 1:1:10;
data2 = 10:10:100;
data =[data1; data2];
T1 = table(data);
writetable(T1)

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Walter Roberson 2019-5-1

In the majority of cases you should create the variables as with tables columns not rows

请先登录，再进行评论。

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

Answer 1

Star Strider 2019-5-1

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/459666-how-to-write-data-to-an-excel-file#answer_373175

在 MATLAB Online 中打开

The table function prefers column vectors. I would save them as columns:

data1 = 1:1:10;
data2 = 10:10:100;
data =[data1(:), data2(:)];
T1 = table(data);

You can convert them back to row vectors later, if necessary, when you read the file. It is best to provide the path name as well as the file name to writetable. This way, you know where it is and what its name is. If you want to save it as an Excel file, be sure that you designate the '.xlsx' extension.

2 个评论
显示无隐藏无

VR 2019-5-1

在 MATLAB Online 中打开

Thanks for your suggestions. I tried this and got an error:

data1 = 1:1:10;
data2 = 10:10:100;
data =[data1(:) data2(:)]; % to make them column vectors
T1 = table(data);
T1.Properties.VariableNames = {'Name' 'Age'}
writetable(T1, 'Table.xls', 'Sheet', 'MySheetName')

Error is: The VariableNames property must contain one name for each variable in the table.

Star Strider 2019-5-1

在 MATLAB Online 中打开

As always, my pleasure.

Create ‘T1’ as:

T1 = table(data1(:),data2(:), 'VariableNames',{'Name' 'Age'});

That works.

Concatenating the variables as one variable is permitted, although if you want to give them different names, you need to have the number of columns equal the number of variable names.

请先登录，再进行评论。