MATLAB: Read and save multiple excel files into one spreadsheet in one excel file

combiningexcel filesreadsavespreadsheetxlsread

I am new to Matlab, and need to combine excel files.
I have one folder (C:\\desktop\data\) containing 200 excel files with names are like data1.xls, data2.xls, data3.xls, … Each excel file has three columns' data. I want to read all the data into one spreadsheet in one excel file, first three columns for the data1.xls, send three columns for the data2.xls,… How can I do it? Thank you.

Best Answer

Hello addy,
I attach a simple sample script.
Please save all files in the same folder and run the script.
Regards,
stozaki
Related Question