Merge different excel files into one big matrix with a loop
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Ricardo López
le 1 Déc 2020
Réponse apportée : Stephan
le 1 Déc 2020
Good morning,
I have 10 big excel files containing hourly data for 2 years and I would like to merged them all into one table in matlab. I tried uploading them one by one and then merge them into one matrix using vertmat but it takes too long.
Does anyone know how to loop this process?
Thank you
0 commentaires
Réponse acceptée
Stephan
le 1 Déc 2020
Here is how to start with this:
If the files are named in a proper way it is easy to automate this process. Once you have this you can concatenate the data as needed for your purpose.
0 commentaires
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Spreadsheets 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!