Inserting excel files from different folders for different processing
3 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Sam
el 2 de Dic. de 2013
Respondida: Image Analyst
el 2 de Dic. de 2013
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 comentarios
Respuesta aceptada
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
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
Más respuestas (1)
Image Analyst
el 2 de Dic. de 2013
See code examples in the FAQ: http://matlab.wikia.com/wiki/FAQ#How_can_I_process_a_sequence_of_files.3F
If you need to know how to recurse into subfolders, see the file I attached below (in blue).
0 comentarios
Ver también
Categorías
Más información sobre Spreadsheets en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!