清空筛选条件
清空筛选条件

How to create multiple excel sheets in Matlab?

154 次查看（过去 30 天）
Milad Zarei
Milad Zarei 2017-9-12
评论： Milad Zarei 2017-9-12
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.

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

采纳的回答

OCDER
OCDER 2017-9-12
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')
  1 个评论
OCDER
OCDER 2017-9-12
编辑：OCDER 2017-9-12
Haha, looks like 3 of us submitted an answer at the same time. Matlab Answer should provide a notice when hitting "Submit" button - "There has been new activity / answer to this question. Check?"

请先登录，再进行评论。

更多回答（2 个）

Image Analyst
Image Analyst 2017-9-12
Since sheet is a variable that you set but never use, how about you use it???
writetable(Tab2, filename, 'sheet', sheet, 'Range', 'A1')
KL
KL 2017-9-12
编辑：KL 2017-9-12
sheet1 = 1;
writetable(Tab1,filename,'sheet',sheet1 ,'Range','A1')
sheet2 = 2;
writetable(Tab2,filename,'sheet',sheet2,'Range','A1')
You should just use that sheet variable in the command. You missed it pretty close.

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by