Inserting excel files from different folders for different processing

4 visualizaciones (últimos 30 días)
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

Respuesta aceptada

Jürgen
Jürgen el 2 de Dic. de 2013
Hi, your question looks similar to: http://www.mathworks.com/matlabcentral/newsreader/view_thread/274014 regards,J
  2 comentarios
Sam
Sam el 2 de Dic. de 2013
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
Jürgen el 2 de Dic. de 2013
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

Iniciar sesión para comentar.

Más respuestas (1)

Image Analyst
Image Analyst el 2 de Dic. de 2013
If you need to know how to recurse into subfolders, see the file I attached below (in blue).

Community Treasure Hunt

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

Start Hunting!

Translated by