How to writematrix with a different sheet name in a for loop matlab

Question

Rami 2019-4-29

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/459207-how-to-writematrix-with-a-different-sheet-name-in-a-for-loop-matlab

评论： Rami 2019-4-29

I have the following vector of arrays

AzizSheetName ={'Joint Angle R.Ankle.X', 'Joint Angle R.Ankle.Y', 'Joint Angle R.hip.X', 'Joint Angle R.hip.Y', 'Joint Moment R.Ankle.X', 'Joint Moment R.Ankle.Y', 'Joint Moment R.hip.X', 'Joint Moment R.hip.Y'};

and there shall be the names of the sheets of a xlsx file that I would like to create

for j=1:numel(sheet_name)
  writematrix(NewData{j},Newfilename,AzizSheetName(j))
end

Obviously this does not work, and this is the one that works

for j=1:numel(sheet_name)
  writematrix(NewData{j},Newfilename,'Sheet',j)
end

However, I do not want things to be named sheet 1, sheet 2, ect.

Can someone help me please?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Jan 2019-4-29

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/459207-how-to-writematrix-with-a-different-sheet-name-in-a-for-loop-matlab#answer_372840

在 MATLAB Online 中打开

What about

AzizSheetName ={'Joint Angle R.Ankle.X', 'Joint Angle R.Ankle.Y', 'Joint Angle R.hip.X', 'Joint Angle R.hip.Y', 'Joint Moment R.Ankle.X', 'Joint Moment R.Ankle.Y', 'Joint Moment R.hip.X', 'Joint Moment R.hip.Y'};
for j=1:numel(sheet_name)
  writematrix(NewData{j}, Newfilename, 'Sheet', AzizSheetName{j});
  %                                    ^^^^^^^               ^ ^  curly braces 
end