フィルターのクリア
フィルターのクリア

How to merge several Excel files with large datasets in MATLAB

2 ビュー (過去 30 日間)
Saara-Liis Lutsar
Saara-Liis Lutsar 2021 年 2 月 9 日
編集済み: 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