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

2 次查看（过去 30 天）
addy fang
addy fang 2020-7-23
回答： stozaki 2020-8-3
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.

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

采纳的回答

stozaki
stozaki 2020-8-3
Hello addy,
I attach a simple sample script.
Please save all files in the same folder and run the script.
Regards,
stozaki

更多回答（0 个）

类别

在 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