Routine that recall various files and apply a script

Hello everyone, I have a question. I wrote a simple script that analyse a xlsx file. I have many of these files in a single directory. Can someone recommend me a skeleton of a routine that automatically recall these files and apply the script at each file? Thank you very much.

Answer 1

[Walter Roberson]

projectdir = 'C:\Directory\Where\The\FilesAre';

dinfo = dir( fullfile( projectdir, '*.xlsx') );

filenames = fullfile( projectdir, {dinfo.name} );

for K = 1 : length(filenames)
   thisfile = filenames{K};
   [num, txt, raw] = xlsread(thisfile);
   ...
 end

[Guglielmo Giambartolomei]

Thank you Walter Roberson, but I'm too a beginner to understand your code. I appreciate anyway; thank you very much!

[Walter Roberson]

projectdir = 'C:\Directory\Where\The\FilesAre';
cd(projectdir);

dinfo = dir( '*.xlsx' );

for K = 1 : length(dinfo)
   thisfile = dinfo(K).name;
   [num, txt, raw] = xlsread(thisfile);
   ...
 end

dir() returns a structure array of information about the files it finds. You need to index that structure at an offset to find information for one file. One of the fields that is recorded for every file is "name", the name of the file. Pull that out of the structure and read the information from the file.

Answer 2

[Jan]

This sounds like a frequently asked question. Then a search in the net should be successful. Et voila: FAQ: How can I process a sequence of files

[Guglielmo Giambartolomei]

You're right Jan, and I thank you but it's not clear what the code in your link do.