Run code through multiple excel files

Question

krysten spencer 2018-2-18

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/383392-run-code-through-multiple-excel-files

编辑： krysten spencer 2018-2-19

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

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Are Mjaavatten 2018-2-19

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/383392-run-code-through-multiple-excel-files#answer_305934

编辑：Are Mjaavatten 2018-2-19

在 MATLAB Online 中打开

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

4 个评论
显示 2更早的评论隐藏 2更早的评论

krysten spencer 2018-2-19

在 MATLAB Online 中打开

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