Merge different excel files into one big matrix with a loop

1 次查看（过去 30 天）
Ricardo López
Ricardo López 2020-12-1
回答： Stephan 2020-12-1
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

请先登录，再回答此问题。

采纳的回答

Stephan
Stephan 2020-12-1
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.

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Cell Arrays 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by