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

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.)?

Answer 1

[Darshan Ramakant Bhat]

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:

https://www.mathworks.com/help/matlab/ref/readtable.html

https://www.mathworks.com/help/matlab/ref/writetable.html

https://www.mathworks.com/help/matlab/import_export/import-a-worksheet-or-range.html

https://www.mathworks.com/help/matlab/ref/xlsread.html

https://www.mathworks.com/help/matlab/ref/xlswrite.html

You can refer to below MATLAB answer posts as a starting point:

https://www.mathworks.com/matlabcentral/answers/264818-how-can-i-combine-multiple-excel-files-in-a-single-new-excel-file

https://www.mathworks.com/matlabcentral/answers/301925-how-can-i-combine-multiple-excel-files-in-a-single-new-excel-file