How to run calculation based on excel files in a folder path via for loop

1 次查看（过去 30 天）

显示更早的评论

Emily 2022-6-22

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1746020-how-to-run-calculation-based-on-excel-files-in-a-folder-path-via-for-loop

评论： Walter Roberson 2022-6-22

I'm trying to create a GUI that will ask the user for a folder path and do some calculations based on it.

There's anywhere between 1-15 files per folder.

I'm stuck at printing the table output and having matlab ignore any temporary files that starts with ~$

filePattern = fullfile(myFolder, '*.xlsx');

theFiles = dir(filePattern);

for k=1: length(theFiles)

baseFileName= theFiles(k).name;

fullFileName=fullfile(myFolder, baseFileName);

Day{k}=extractBetween(fullFileName,"Day","_");

data1{k} =xlsread(theFiles(k), 2,'F10:end10');

TotalTemp{k}= sum(data1{k});

data2{k} =xlsread(theFiles(k), 3,'A10:end10');

TotalCost{k}= mean(data2{k});

T=table(Day, TotalTemp, TotalCost)

end

3 个评论
显示 1更早的评论隐藏 1更早的评论

Emily 2022-6-22

编辑：Walter Roberson 2022-6-22

在 MATLAB Online 中打开

I was able to update the code to skip the tempoary files.

filelist = dir;

filelist = filelist(~startsWith({filelist.name}, '~$''));

And have updated to readmatrix.

I'm still having trouble getting it to loop and print out the correct output.

for k=1: length(theFiles)
    baseFileName= theFiles(k).name;
    fullFileName=fullfile(myFolder, baseFileName);
    
    day{k}=extractBetween(fullFileName,"Day","_");
    
    data1{k} =readMatrix(theFiles(k),'Sheet', 'B', 'Range','F10:end10');
    data1{k}=rmmissing(data1{k});
    total1{k}= sum(data1{k}); 
    
    data2{k} =readMatrix(theFiles(k),'Sheet', 'C', 'Range','A10:end10');
    data2{k}=rmmissing(data2{k});
    total2{k}= mean(data2{k}); 
    
    total3{k}=total1{k}*total2{k}-20;
    
    T=table(day, total1, total2, total3);
    
end