load files automatically and combine
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
I have a lot of (about 100) short consequetive excel files with datestamps and data. I want to automatically load them in to matlab (all files in a specific folder), and them combine them into one file.
The name of the files is not changing with only a number, as it contains the timestamp of the first datapoint. So can I automatically load all files from a specific folder?
And how can I subsequently combine these files (or the date and data within this file) into one file?
0 commentaires
Réponse acceptée
KSSV
le 5 Avr 2019
YOu should try some thing like below. It should work, if any error let me know.
files = dir('*xlsx') ;
N = length(files) ;
T = readtable(files(1).name)
for i = 2:N
T1 = readtable(files(i).name)
T = [T ; T1] ;
end
writetable(T,'test.xlsx')
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Dates and Time dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!