Run a code for all excel files in a folder?

Question

Indra 2018-10-15

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/424158-run-a-code-for-all-excel-files-in-a-folder

评论： Bob Thompson 2018-10-17

Hello, I need to run a code (Dataprocess.m) for all excel files in a folder. When I am running dataprocess.m for one file, it's working. How can I run it sequentially for all the excel files?

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Bob Thompson 2018-10-15

在 MATLAB Online 中打开

I would write a for loop to run through a directory.

files = dir(folder,'*.xlsx') % Syntax here is not going to be perfect, but I'm pretty sure dir is the correct command.
for k = 1:length(files)
 data_process_code_file_name_var = files(k).name % Not positive files is actually a structure class, you will have to try it
 Dataprocess % Execute code
end

请先登录，再进行评论。

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

Answer 1

madhan ravi 2018-10-16

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/424158-run-a-code-for-all-excel-files-in-a-folder#answer_341563

Read the link below: https://www.mathworks.com/matlabcentral/answers/424007-how-can-i-analyze-all-the-data-files-at-the-same-time#answer_341425

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

Answer 2

Indra 2018-10-16

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/424158-run-a-code-for-all-excel-files-in-a-folder#answer_341744

Thanks Bob, I made a loop as per your suggestion in a script:

files = dir('*.xls') % Syntax here is not going to be perfect, but I'm pretty sure dir is the correct command . for k = 1:length(files ) data_process_code_file_name_var = files(k).name; % Not positive files is actually a structure class, you will have to try it DataProcess % Execute code end

Then I run my Dataprocess.m code as below:

close all; clear all; clc; % [FileName, Pathname] = uigetfile({'*.xls';'*.xlsx'},'select the excel file'); % % % FileName = [Pathname FileName]; %FileName = '1605301321.xls'; FileName = 'data_process_code_file_name_var';

But it's not working

3 个评论
显示 1更早的评论隐藏 1更早的评论

Indra 2018-10-17

Undefined variable "files" or class "files".

Error in Untitled (line 3)

Bob Thompson 2018-10-17

What is 'files' defining itself as? Does the dir() command come up with anything? Did you change it at all? You are probably going to have to, and I would suggest looking up the documentation on it first to make sure it is being applied correctly (I.e. right location, right options input, etc.).

请先登录，再进行评论。