Export Data from Matlab to Excel

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!

Answer 1

[Andrei Bobrov]

Try it

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

[Konstantinos]

Thanks a lot! but if I want W1 to sheet 1 and W2 to sheet 2 ?

[Andrei Bobrov]

xlswrite('default1.xlsx',W1,1,'B3:B22');
xlswrite('default1.xlsx',W2,2,'С3:C22');

[Konstantinos]

I really appreciate your help!