Read and save multiple excel files into one spreadsheet in one excel file
조회 수: 1 (최근 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!