Combining multiple Excel spreadsheets into one (strings + numerical values)
Show older comments
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.)?
Answers (1)
Darshan Ramakant Bhat
on 17 Jan 2018
1 vote
There are many functions available in MATLAB to read specified columns from excel and write it to the other excel file. I hope following functions will be useful for you:
You can refer to below MATLAB answer posts as a starting point:
Categories
Find more on Spreadsheets in Help Center and File Exchange
on 17 Jan 2018
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
