BUILDING A TABLE ON EXCEL
2 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
MAHMOUD ALZIOUD
el 11 de Dic. de 2017
Comentada: MAHMOUD ALZIOUD
el 12 de Dic. de 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 comentarios
Respuesta aceptada
Image Analyst
el 12 de Dic. de 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 comentarios
Más respuestas (0)
Ver también
Categorías
Más información sobre Tables en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!