Merge different excel files into one big matrix with a loop

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

Answer 1

[Stephan]

Here is how to start with this:

https://de.mathworks.com/help/matlab/import_export/process-a-sequence-of-files.html

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.