Using multiple files from folder

1 次查看（过去 30 天）
Alexandros
Alexandros 2011-11-28
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
  1 个评论
Alexandros
Alexandros 2011-11-28
I YES FORGOT
THERE IS ALSO OTHER FILES IN THERE WHICH I DONT NEED

请先登录，再进行评论。

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

采纳的回答

Jan
Jan 2011-11-28
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
  1 个评论
Alexandros
Alexandros 2011-11-28
This is exactly what i needed. Now i just put list(ilist).name inside a variable and continue with my excel actions

请先登录，再进行评论。

更多回答（0 个）

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by