Basic Excel Import Error

1 view (last 30 days)
xander fong
xander fong on 15 Jul 2015
Answered: Geoff Hayes on 15 Jul 2015
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."

Accepted Answer

Geoff Hayes
Geoff Hayes on 15 Jul 2015
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.

More Answers (0)

Community Treasure Hunt

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

Start Hunting!