Info
此问题已关闭。 请重新打开它进行编辑或回答。
XLS and for loops
1 次查看(过去 30 天)
显示 更早的评论
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 个评论
回答(2 个)
Walter Roberson
2013-2-8
x{i} = List(i,:).name;
and when you want to get back an individual name, x{i} again for appropriate "i"
0 个评论
此问题已关闭。
另请参阅
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!