How to merge several Excel files with large datasets in MATLAB

5 次查看（过去 30 天）
Saara-Liis Lutsar
编辑： darova 2021-2-9
How do I merge several (9) Excel files into one MATLAB file? I have data in columns from different stations where rows are time data. The nine files are for each year. The columns (stations) match in most files, so I want them to be in one column from different years. The columns (stations) which do not have data in some years, should still be included but then with no numerical data, but shouldn't be in the way for statistical analysis.

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

回答（1 个）

darova
darova 2021-2-9
编辑：darova 2021-2-9
  • Use dir to create list of file names in current directory
  • Use for loop to read each file and get the data

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by