MATLAB: Basic Excel Import Error

excelimport

Hello, I'm new to Matlab and am trying to create the beginning of a script that lists all *.XYZ files from excel and then stores their file contents. The beginning of the script is:
dirName = ':/Users/xanderfong/Documents/EOD’;   %choose directory
files = dir('*.xlsx');   % list all *.xyz files
files = {files.name}';     % transpose file names
data = cell(numel(files),1); % store file contents
for i=1:numel(files)
    % load file into 'data' variable 
    data{i} = importfile(files{i},'Test');
end
However, it returns
dirName = ':/Users/xanderfong/Documents/EOD’;   
           |
Error: String is not terminated properly."

Best Answer

xander - the final quote on your dirName string is not the same as your starting quote. (It is a ’ and not a '.) Try changing this to
 dirName = ':/Users/xanderfong/Documents/EOD';
You may need to remove the colon too.
Related Question