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 Low-Level File I/O 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!