select all .xls files together and read one by one( without naming .xls file in a specified name)
Show older comments
in a folder there are several .xls files and name of these aren't specified. it's needed by selecting 1 or 2 or 3 or ever other numbers of those, one by on has been read by MATLAB and then display this message fprint'filename.xls checked' for example:these files are in folder: a.xls, as.xls, lku.xls, fd.xls,... after reading each one, matlab show message about that, 'like:a.xls checked'
my opinion:
cd(path of the folder);
put names of all files in a matrix like r
for i=1:size(r,1)
[dfile,pathname]=uigetfile('*.xls','Select Data File');
f = xlsread(dfile(1,i))
func(f)%%func is a function that do something on f and give some outputs
fprint'filename.xls checked'
end
thanks a lot
Accepted Answer
More Answers (0)
Categories
Find more on Workspace Variables and MAT Files in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!