Run a code for all excel files in a folder?
조회 수: 7 (최근 30일)
이전 댓글 표시
Hello, I need to run a code (Dataprocess.m) for all excel files in a folder. When I am running dataprocess.m for one file, it's working. How can I run it sequentially for all the excel files?
댓글 수: 1
Bob Thompson
2018년 10월 15일
I would write a for loop to run through a directory.
files = dir(folder,'*.xlsx') % Syntax here is not going to be perfect, but I'm pretty sure dir is the correct command.
for k = 1:length(files)
data_process_code_file_name_var = files(k).name % Not positive files is actually a structure class, you will have to try it
Dataprocess % Execute code
end
답변 (2개)
Indra
2018년 10월 16일
댓글 수: 3
Bob Thompson
2018년 10월 17일
What is 'files' defining itself as? Does the dir() command come up with anything? Did you change it at all? You are probably going to have to, and I would suggest looking up the documentation on it first to make sure it is being applied correctly (I.e. right location, right options input, etc.).
참고 항목
카테고리
Help Center 및 File Exchange에서 File Operations에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!