Routine that recall various files and apply a script

Question

Guglielmo Giambartolomei 2016-11-21

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/313285-routine-that-recall-various-files-and-apply-a-script

评论： Walter Roberson 2016-11-23

Hello everyone, I have a question. I wrote a simple script that analyse a xlsx file. I have many of these files in a single directory. Can someone recommend me a skeleton of a routine that automatically recall these files and apply the script at each file? Thank you very much.

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

请先登录，再进行评论。

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

Answer 1

Walter Roberson 2016-11-22

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/313285-routine-that-recall-various-files-and-apply-a-script#answer_244256

在 MATLAB Online 中打开

projectdir = 'C:\Directory\Where\The\FilesAre';
dinfo = dir( fullfile( projectdir, '*.xlsx') );
filenames = fullfile( projectdir, {dinfo.name} );
for K = 1 : length(filenames)
   thisfile = filenames{K};
   [num, txt, raw] = xlsread(thisfile);
   ...
 end

2 个评论
显示无隐藏无

Guglielmo Giambartolomei 2016-11-23

Thank you Walter Roberson, but I'm too a beginner to understand your code. I appreciate anyway; thank you very much!

Walter Roberson 2016-11-23

在 MATLAB Online 中打开

projectdir = 'C:\Directory\Where\The\FilesAre';
cd(projectdir);
dinfo = dir( '*.xlsx' );
for K = 1 : length(dinfo)
   thisfile = dinfo(K).name;
   [num, txt, raw] = xlsread(thisfile);
   ...
 end

dir() returns a structure array of information about the files it finds. You need to index that structure at an offset to find information for one file. One of the fields that is recorded for every file is "name", the name of the file. Pull that out of the structure and read the information from the file.

请先登录，再进行评论。