XLS and for loops

Hi! I have some folders, and in these folders I have xls files. I would like create a program for reading these files, copying a single line and re-writing the lines in a new xls files.

So the first step is allowing the program to know which xls files read:

List=dir(['C:\Documents and Settings\folder1\' filesep '*.xls']);
n1= length(List)
for i=1:1:n1
   x=List(i,:).name
end

...and I have a problem! My idea was to create a X matrix where there are file names. Then I'll create a second part (in the for loop) with xlsread program and the X matrix ( may be: A=xlsread(X)), and then a third part for copying the single line and rewriting. So far, my problems are: - how can I avoid to overwrite the data in the matrix X? - What should I write for reading the xls file?

I hope i was clear. Thank you and sorry for my bad english... Ale

Answer 1

[Walter Roberson]

x{i} = List(i,:).name;

and when you want to get back an individual name, x{i} again for appropriate "i"

Answer 2

[Jan]

Data = cell(1, nFiles);
for k = 1:nFiles
  file = List(i,:).name;
  Data{k} = xlsread(file);
end

Less cryptic names of variables allow to keep the overview in grater programs.