BUILDING A TABLE ON EXCEL
2 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
MAHMOUD ALZIOUD
le 11 Déc 2017
Commenté : MAHMOUD ALZIOUD
le 12 Déc 2017
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 commentaires
Réponse acceptée
Image Analyst
le 12 Déc 2017
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
3 commentaires
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Tables dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!