Export Data from Matlab to Excel

2015 3 11
1 个回答
回答已采纳
更新时间：2015 3 11
7 次查看（30 天）

0 个投票

Each time I run my code in matlab it produces 2 matrices: W1 (20 x 1) and W2 (20 x 1).I want to aytomatically pass the values of these 2 matrices in an existing excel file, which is called: default1.xlsx and it is located in my desktop.Additionally, I want to pass the values of the matrices in certain cells in excel,i.e B3:B22 for W1 and C3:C22 for W2.Can anyone share with me the appropriate code for this in order to avoid the copy/paste command ?
Any help could be useful. Thanks in advance!

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

 采纳的回答

Andrei Bobrov
Andrei Bobrov 2015-3-11

1 个投票

Try it
xlswrite('default1.xlsx',[W1,W2],1,'B3:C22');

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

Konstantinos
Konstantinos 2015-3-11
Thanks a lot! but if I want W1 to sheet 1 and W2 to sheet 2 ?
Andrei Bobrov
Andrei Bobrov 2015-3-11
编辑：Andrei Bobrov 2015-3-11
xlswrite('default1.xlsx',W1,1,'B3:B22');
xlswrite('default1.xlsx',W2,2,'С3:C22');
Konstantinos
Konstantinos 2015-3-11
I really appreciate your help!

请先登录，再进行评论。

更多回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by