Run code through multiple excel files

2018 2 18
1 个回答
回答已采纳
更新时间：2018 2 19
2 次查看（30 天）

0 个投票

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

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

 采纳的回答

Are Mjaavatten
Are Mjaavatten 2018-2-19
编辑：Are Mjaavatten 2018-2-19

0 个投票

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
krysten spencer 2018-2-19
That works perfectly, thank you!
krysten spencer
krysten spencer 2018-2-19
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
Walter Roberson 2018-2-19
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
krysten spencer 2018-2-19
编辑：krysten spencer 2018-2-19
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.

请先登录，再进行评论。

更多回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by