Basic Excel Import Error
1 view (last 30 days)
Show older comments
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."
0 Comments
Accepted Answer
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.
0 Comments
More Answers (0)
See Also
Categories
Find more on Data Import from MATLAB in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!