I would like this code to run through multiple files(which it does already) but then save the output in a new excel file – each row being a new file.
ext='.xlsx'; xl_file_list=dir(['p_*' ext]); xl_file_list={xl_file_list(:).name}; xl_response_list=cellfun(@(x) ['p' x(3:(end-length(ext))) 'r' ext],... xl_file_list,'uniformoutput',false); for file_number=1:length(xl_file_list) outputfilename=xl_response_list{file_number}; numData = xlsread(xl_file_list{file_number}); p = outputfilename TP1 = numData(:,1) TP2 = numData(:,2) TP3 = numData(:,3) TP4 = numData(:,4) tp1 = sum(TP1) tp2 = sum(TP2) tp3 = sum(TP3) tp4 = sum(TP4) data = {p,tp1,tp2,tp3,tp4} end
Best Answer