how to run multiple xlsx files once

1 次查看（过去 30 天）
Mike
Mike 2019-10-31
评论： galaxy 2019-11-1
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 个评论
Alex Mcaulley
Alex Mcaulley 2019-10-31
Without more details, you will need a loop to call the function for each file

请先登录，再进行评论。

请先登录，再回答此问题。

回答（1 个）

galaxy
galaxy 2019-10-31
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 个评论
Mike
Mike 2019-10-31
编辑：Mike 2019-10-31
Hey,
thank you,
but I have a problem with "findfiles", it is an 'Undefined function or variable'.
do you know maybe why?
thanks
galaxy
galaxy 2019-11-1
You can copy findfiles function to your source code.
--> It will be OK

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by