Read and save multiple excel files into one spreadsheet in one excel file
2 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
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 Commenti
Risposta accettata
stozaki
il 3 Ago 2020
Hello addy,
I attach a simple sample script.
Please save all files in the same folder and run the script.
Regards,
stozaki
0 Commenti
Più risposte (0)
Vedere anche
Categorie
Scopri di più su Spreadsheets in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!