MATLAB: How to create multiple excel sheets in Matlab

excelexporttable

I have 2 tables, and I am trying to use writetable commend to create Excel sheet. When I try to have more than one sheet, it would not work. It just overwrites the first sheet. This is piece of script I use: By the way, I am running Matlab on a Macbook.
 A = randn(5,5);
 Tab1 = table(A,'VariableNames',{'X1' 'X2' 'X3' 'X4' 'X5'});
 B = rand(5,1);
 Tab2 = table(B,'VariableNames',{'Y1'});
 sheet = 1;
 writetable(Tab1,filename,'sheet',1,'Range','A1')
 sheet = 2;
 writetable(Tab2,filename,'sheet',1,'Range','A1')
Can you give me some tips? Thanks.

Best Answer

Looks like you're overwriting sheet 1 in the last line of your script.
 sheet = 1;
 writetable(Tab1,filename,'sheet',1,'Range','A1')
 sheet = 2;
 writetable(Tab2,filename,'sheet',1,'Range','A1') %This is overwriting sheet 1
Try this:
 sheet = 1;
 writetable(Tab1,filename,'sheet',sheet,'Range','A1')
 sheet = 2;
 writetable(Tab2,filename,'sheet',sheet,'Range','A1')
Related Question