Using multiple files from folder

Hello

I have a script that takes some xls files and rearrange them to put them into a new xls files. While also i have a folder where all the initial xls files exist. The names of the xls files are BAG?.xls and TEMP?.xls where ? can be from 1 to millions of file.

e.g. in the folder BAG1.xls TEMP1.xls BAG2.xls TEMP2.xls BAG3.xls TEMP3.xls exist.

Now my script has been program so that it ask me every time the BAG file and TEMP file name and does it's actions to rearrange them.

How is it possible to tell the script to scan the folder to see how many files we have then to take BAG1 and TEMP1 do the actions, then automatically take BAG2 and TEMP2 do the actions and to continue like this?

Thank you in advance Alex

[Alexandros]

I YES FORGOT

THERE IS ALSO OTHER FILES IN THERE WHICH I DONT NEED

Answer 1

[Jan]

This is explained in the FAQ:

http://matlab.wikia.com/wiki/FAQ#How_can_I_process_a_sequence_of_files.3F

Reading the FAQ is strongly recommended, because all beinners can profit from the frequent errors of others and they do not have to re-invent the errors again.

See the dir command.

list = dir(fullfile(YourDataPath, 'BAG*.xls'));
for iList = 1:length(list)
  disp(list(iList).name);
  % Do your processing here
end

[Alexandros]

This is exactly what i needed. Now i just put list(ilist).name inside a variable and continue with my excel actions