Inserting excel files from different folders for different processing

Question

Sam 2013-12-2

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/108255-inserting-excel-files-from-different-folders-for-different-processing

回答： Image Analyst 2013-12-2

Hi all,

I have a question about inputting data into MATLAB for some kind of analysis. I have a large amount of excel data inside different folders. Let's suppose folders are like: wp1, wp2,... and bp1, bp2,...; and inside wp folders are excel files like t1, t2,... & similarly for bp folders we have excel files like t1, t2,...

A special kind of process according to the folder name (wp or bp) should be done on excel files. The problem is how can I import all these excel files from different folders in MATLAB considering the point that MATLAB recognizes the name of the folder (wp or bp) and doing a certain process for the excel files.

Many thanks

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

请先登录，再进行评论。

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

Answer 1

Jürgen 2013-12-2

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/108255-inserting-excel-files-from-different-folders-for-different-processing#answer_116943

Hi, your question looks similar to: http://www.mathworks.com/matlabcentral/newsreader/view_thread/274014 regards,J

2 个评论
显示无隐藏无

Sam 2013-12-2

Thanks Jürgen,

similar but a big problem up there:

there are unknown number of folders with unknown number of excel files inside each one. The problem is how can you change the path when you don't know the number of folders (i.e. a dynamic path is needed to be generated according to number of folders).

And the second problem is the excel files inside each folder have similar names, how is it possible to call them for certain processing avoiding overwriting them!

Regards, Sam

Jürgen 2013-12-2

在 MATLAB Online 中打开

you do not need to know the number of folder or the number of files with the dir command all files/folders are put in "FileList"

FileList = dir('path');
FileList = FileList(~[FileList.isdir]); %remove directories
[junk, sortorder] = sort([FileList.datenum]);
FileList = FileList(sortorder); %list is now in ascending date order
numfiles = numel(FileList);
In = cell(numfiles,1);
% Processing the images in a loop
for ii = 1:numfiles
   do something with FileList(ii).name
  end