清空筛选条件
清空筛选条件

Info

此问题已关闭。 请重新打开它进行编辑或回答。

XLS and for loops

2 次查看（过去 30 天）
Alessandro Innocenti
关闭： MATLAB Answer Bot 2021-8-20
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

此问题已关闭。

回答（2 个）

Walter Roberson
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"
Jan
Jan 2013-2-8
编辑：Jan 2013-2-8
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.

此问题已关闭。

标签

Community Treasure Hunt

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

Start Hunting!

Translated by