Combining multiple Excel spreadsheets into one (strings + numerical values)

3 次查看（过去 30 天）
Leon
Leon 2018-1-15
回答： Darshan Ramakant Bhat 2018-1-17
I have a total of around 100 Excel files. Each of them contain the same types of information in the same column order. For example: Column1: Year, Column2: Month, etc.
It also contains a two or three row header at the top rows.
Some of the information is numerical values, others are strings (e.g., Station no., A05, TP5, etc.).
How do I write a simple program to combine them into one single lump sump Excel spreadsheet with everything as is (header, numerical values, string, etc.)?

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

回答（1 个）

Darshan Ramakant Bhat

类别

在 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