I want to xlsread in many files
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
Jeong_evolution
am 4 Jul. 2016
Kommentiert: Jeong_evolution
am 4 Jul. 2016
hello.
[num txt raw] = xlsread('1.xlsx')
This code just imported only 1 file.
But i want to import many files.
After imported, in this file I want to average time data.
For example,
12:00 12:01 12:02 ... 01:00 - raw data
12:00 12:15 12:30 ...01:00 - revised data
I want to expression like resvised data in file.
0 Kommentare
Akzeptierte Antwort
KSSV
am 4 Jul. 2016
xlfiles = dir('*.xlsx'); % You are in the folder of xl files
Nfiles = length(xlfiles) ; % number of xl files
% loop for each file
for i = 1:Nfiles
fname = xlfiles(i).name ; % file name
data = xlsread(fname) ; % read the file
%%do what you want %%%
end
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Data Import and Analysis finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!