how to run multiple xlsx files once
4 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Hello,
I have a code which use one xlsx file from source folder, analyzes it and creates file into destination folder.
I would like to use this code as it is, but use multiple xlsx files at once at the source folder, and creates all new files at once into the destination folder.
thanks
1 comentario
Alex Mcaulley
el 31 de Oct. de 2019
Without more details, you will need a loop to call the function for each file
Respuestas (1)
galaxy
el 31 de Oct. de 2019
You can use following steps:
% select path
work_path = uigetdir('pwd', 'Select folder');
% find all xlsx files in folder
% findfiles function can get in: https://www.mathworks.com/matlabcentral/fileexchange/172-findfiles
work_files = findfiles('*.xlsx', work_path);
num_file = length(work_files);
for cnt_file=1:num_file
%% analysis as your code
% when want to get name of current excel file, use work_files(cnt_file), convert from cell to string if need
end
2 comentarios
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!