BUILDING A TABLE ON EXCEL

Question

MAHMOUD ALZIOUD 2017-12-11

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/372426-building-a-table-on-excel

评论： MAHMOUD ALZIOUD 2017-12-12

Hi everyone, I am trying to build a table based on some analysis done by MATLAB, but i keep get the error: The VariableNames property must contain one name for each variable in the table. how can i fix this please. this is my code:

case_numbers=1:15;
Percentages{K}=[Percent_case1{K};Percent_case2{K};Percent_case3{K};Percent_case4{K};Percent_case5{K};Percent_case6{K};Percent_case7{K};Percent_case8{K};Percent_case9{K};Percent_case10{K};Percent_case11{K};Percent_case12{K};Percent_case13{K};Percent_case14{K};Percent_case15{K}];
n=15;
month=kron(month(K), ones(n,1));
Station=kron(Station(K), ones(n,1));
%the loop through variables to establish exel tables FOR EACH CARD:
Z={'Case_Number' 'Month' 'Card_Name' 'Percentage'};
D=[case_numbers', kron(month(K), ones(n,1)), kron(Station(K), ones(n,1)),Percentages];
filename = 'ourData3.xlsx';
W = table()..., 'VariableNames', varNames);
uc = num2cell(D, 1);
W = table(uc{:}, 'VariableNames', Z)
writetable(W,filename,'Sheet',1,'Range','D1')
x1=filename;
xtr=strcat('C:\Users\maa285\Desktop\New Folder\',x1); 
fid = fopen( xtr, 'wt' );

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

请先登录，再进行评论。

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

Answer 1

Image Analyst 2017-12-12

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/372426-building-a-table-on-excel#answer_295826

We do not have Percent_case1, etc. nor do we have 'ourData3.xlsx', which you forgot to attach, so we can't really help much. From the error message, it sounds like varNames, which you tragically forgot to include, has two or more strings with the same characters in them.

What I can do is to suggest you read this link: http://www.mathworks.com/matlabcentral/answers/6200-tutorial-how-to-ask-a-question-on-answers-and-get-a-fast-answer