BUILDING A TABLE ON EXCEL

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' );

Answer 1

[Image Analyst]

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

[MAHMOUD ALZIOUD]

the ourData3.xlsx is an excel file, to which i want to export data, i am trying to build a table with 4 columns mentioned in Z above, and data will come from 2 cards, each card represents a month of data, each card has 15 cases, that is why finally i will a table with 30 rows for the both cards.

[Image Analyst]

OK. Good luck.

[MAHMOUD ALZIOUD]

thank you