Export Data from Matlab to Excel
1 次查看(过去 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!
0 个评论
采纳的回答
Andrei Bobrov
2015-3-11
Try it
xlswrite('default1.xlsx',[W1,W2],1,'B3:C22');
3 个评论
Andrei Bobrov
2015-3-11
编辑:Andrei Bobrov
2015-3-11
xlswrite('default1.xlsx',W1,1,'B3:B22');
xlswrite('default1.xlsx',W2,2,'С3:C22');
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!