MATLAB: Read excel files from different directories

MATLABread data

Hello,

I have a directory (named 'data') with subdirectories or different names (named 'bol', 'acro' and 'platin')- each of these subdirectories have one or two subdirectories (named 'up' and/or 'down') and then there are excel files that I have to read and modified. How can I create a Matlab code to be able to get to these excel files without moving them to the same directory. Thanks.

Best Answer

Use a combination of dir, isdir, cd and pwd. For more details, see How can I process a sequence of files? on the MATLAB FAQ.

HTH,

Arnaud

Related Solutions

MATLAB: Fullfile to contain multiply file extension

Try:

filePatternCSV = fullfile(handles.sourceFolder, '*.csv'); 
csvFiles = dir(filePatternCSV); 
filePatternXLS = fullfile(handles.sourceFolder, '*.xls'); 
xlsFiles = dir(filePatternXLS);
filePatternODS = fullfile(handles.sourceFolder, '*.ods'); 
odsFiles = dir(filePatternODS);
allFiles= vertcat(csvFiles,xlsFiles,odsFiles);

MATLAB: Strange behavior retrieving directories’ names with dir

Some modifications: cd is faster than pwd, the trailing file separator is not needed, fullfile is smarter than [cd, filesep, results], because it considers the already existing separator in e.g. "C:\":

subdirectories = dir(fullfile(cd, results));

If you want to exclude all files and folders starting with a dot -e.g. a common method under Unix:

subdirectories(strncmp({subdirectories.name}, '.', 1)) = [];

To remove only "." and "..":

subname                        = {subdirectories.name};
subname(strcmp(subname, '.'))  = [];
subname(strcmp(subname, '..')) = [];

Although these two directories have been the first and second entries in the list in all of my tests under Windows95 to Windows7, Suse-Linux, MacOS7/8/9/X, AUX and AIX, I would not rely on this, but use astring comparison always.

Best Answer

Related Solutions

MATLAB: Fullfile to contain multiply file extension

MATLAB: Strange behavior retrieving directories’ names with dir

Related Question