Run code through multiple excel files

I have this code I have written to access a single excel file and go through specific columns and then count the number of non zero elements in that column, the code then prints each columns total in a new excel sheet. What I am trying to do is have this code run through multiple excel sheets doing the same thing but print out one output file - with each new row being the next participants results. Any help would be appreciated!

if true
  % code
numData = xlsread('p_2.xlsx');
participantNumber = numData(2,1);
buttonAmount = numData(:,3);
Ar = nnz(buttonAmount);
buttonAmount2 = numData(:,4);
Br = nnz(buttonAmount2);
buttonAmount3 = numData(:,5);
Xr = nnz(buttonAmount3);
buttonAmount4 = numData(:,6);
Yr = nnz(buttonAmount4);
buttonAmount5 = numData(:,7);
RRr = nnz(buttonAmount5);
buttonAmount6 = numData(:,8);
ZRr = nnz(buttonAmount6);
buttonAmount7 = numData(:,9);
SBr = nnz(buttonAmount7);
buttonAmount8 = numData(:,10);
SLr = nnz(buttonAmount8);
buttonAmount9 = numData(:,11);
SRr = nnz(buttonAmount9);
buttonAmount10 = numData(:,12);
SXr = nnz(buttonAmount10);
sumPresses = Ar+Br+Xr+Yr+RRr+ZRr+SBr+SLr+SRr+SXr
T=table(participantNumber,Ar,Br,Xr,Yr,RRr,ZRr,SBr,SLr,SRr,SXr,sumPresses);
fileName='buttonpresses.xls';
writetable (T,fileName);

end

Answer 1

[Are Mjaavatten]

You could try something like this:

Names = {'participantNumber';'Ar';'Br';'Xr';'Yr';'RRr';'ZRr';'SBr';...
    'SLr';'SRr';'SXr';'sumPresses'};
fileName='buttonpresses.xls';
xlswrite(fileName,Names,'Sheet1','A2');
infiles = {'p_2.xlsx','p_3.xlsx','p_4.xlsx'};
for i = 1:length(infiles)
    numData = xlsread(infiles{i});
    cellname = [char(65+i),'1'];
    xlswrite(fileName,infiles(i),'Sheet1',cellname);

      <your stuff>

      X = [participantNumber,Ar,Br,Xr,Yr,RRr,ZRr,SBr,SLr,SRr,SXr,sumPresses]';
      cellname = [char(65+i),'2'];
      xlswrite(fileName,X,'Sheet1',cellname);
  end

[krysten spencer]

That works perfectly, thank you!

[krysten spencer]

I keep getting this error once I get to column Z Error using xlswrite (line 226) The specified data range is invalid or too large to write to the specified file format. Try writing to an XLSX file and use Excel A1 notation for the range argument, for example, ‘A1:D4’.

Error in nonzerocounter (line 9) xlswrite(fileName,infiles(i),'Sheet1',cellname);

Is their a way to fix this? My code looks like this now

if true
 Names = {'participantNumber';'Ar';'Br';'Xr';'Yr';'RRr';'ZRr';'SBr';...
  'SLr';'SRr';'SXr';'sumPresses'};
fileName='buttonpresses.xlsx';
xlswrite(fileName,Names,'Sheet1','A2');
infiles = {'p_2.xlsx','p_5.xlsx','p_7.xlsx','p_10.xlsx','p_11.xlsx','p_12.xlsx','p_13.xlsx','p_14.xlsx','p_15.xlsx','p_16.xlsx','p_17.xlsx','p_18.xlsx','p_19.xlsx','p_20.xlsx','p_21.xlsx','p_22.xlsx','p_23.xlsx','p_24.xlsx','p_25.xlsx','p_26.xlsx','p_27.xlsx','p_28.xlsx','p_29.xlsx','p_30.xlsx','p_31.xlsx','p_32.xlsx','p_33.xlsx','p_34.xlsx',};
for i = 1:length(infiles)
  numData = xlsread(infiles{i});
  cellname = [char(65+i),'1'];
  xlswrite(fileName,infiles(i),'Sheet1',cellname);
    participantNumber = numData(2,1);
buttonAmount = numData(:,3);
Ar = nnz(buttonAmount);
buttonAmount2 = numData(:,4);
Br = nnz(buttonAmount2);
buttonAmount3 = numData(:,5);
Xr = nnz(buttonAmount3);
buttonAmount4 = numData(:,6);
Yr = nnz(buttonAmount4);
buttonAmount5 = numData(:,7);
RRr = nnz(buttonAmount5);
buttonAmount6 = numData(:,8);
ZRr = nnz(buttonAmount6);
buttonAmount7 = numData(:,9);
SBr = nnz(buttonAmount7);
buttonAmount8 = numData(:,10);
SLr = nnz(buttonAmount8);
buttonAmount9 = numData(:,11);
SRr = nnz(buttonAmount9);
buttonAmount10 = numData(:,12);
SXr = nnz(buttonAmount10);
sumPresses = Ar+Br+Xr+Yr+RRr+ZRr+SBr+SLr+SRr+SXr;
    X = [participantNumber,Ar,Br,Xr,Yr,RRr,ZRr,SBr,SLr,SRr,SXr,sumPresses]';
    cellname = [char(65+i),'2'];
    xlswrite(fileName,X,'Sheet1',cellname);
end

[Walter Roberson]

char(65+i) is going to fail after 25 files. You can grab something from the File Exchange such as https://www.mathworks.com/matlabcentral/fileexchange/28343-column-converter-for-excel

[krysten spencer]

I am just learning how to use matlab and I am not sure how to use this- do you have any examples? Thank you so much for the assistance.