Merge different excel files into one big matrix with a loop
1 visualizzazione (ultimi 30 giorni)
Mostra commenti meno recenti
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 Commenti
Risposta accettata
Stephan
il 1 Dic 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 Commenti
Più risposte (0)
Vedere anche
Categorie
Scopri di più su Spreadsheets in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!