Export Data from Matlab to Excel

2 次查看(过去 30 天)
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
Try it
xlswrite('default1.xlsx',[W1,W2],1,'B3:C22');
  3 个评论
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 个)

Community Treasure Hunt

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

Start Hunting!

Translated by