BUILDING A TABLE ON EXCEL
조회 수: 2 (최근 30일)
이전 댓글 표시
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
채택된 답변
Image Analyst
2017년 12월 12일
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
추가 답변 (0개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Tables에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!