Basic Excel Import Error

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."

Answer 1

[Geoff Hayes]

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.