Loop through excel files and save output to 1 file

1 次查看（过去 30 天）
krysten spencer
krysten spencer 2018-3-5
回答： umichguy84 2018-3-5
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

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

采纳的回答

umichguy84
umichguy84 2018-3-5
You want to add to the data every loop and write it out once at the end. Before loop data = repmat(cell(1,4),length(xl_file_list),1); % Preallocate for speed
Each loop data(file_number) ={p,tp1,tp2,tp3,tp4};
After loop xlswrite(OutFilename, data)

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Downloads 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by