Read and save multiple excel files into one spreadsheet in one excel file
1 visualización (últimos 30 días)
Mostrar comentarios más antiguos
addy fang
el 23 de Jul. de 2020
Respondida: stozaki
el 3 de Ag. de 2020
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 comentarios
Respuesta aceptada
stozaki
el 3 de Ag. de 2020
Hello addy,
I attach a simple sample script.
Please save all files in the same folder and run the script.
Regards,
stozaki
0 comentarios
Más respuestas (0)
Ver también
Categorías
Más información sobre Spreadsheets en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!