Info
This question is closed. Reopen it to edit or answer.
XLS and for loops
1 view (last 30 days)
Show older comments
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
0 Comments
Answers (2)
Walter Roberson
on 8 Feb 2013
x{i} = List(i,:).name;
and when you want to get back an individual name, x{i} again for appropriate "i"
0 Comments
This question is closed.
See Also
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!