Read and save multiple excel files into one spreadsheet in one excel file
2 ビュー (過去 30 日間)
古いコメントを表示
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.
0 件のコメント
採用された回答
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 件のコメント
その他の回答 (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!