Basic Excel Import Error
1 visualizzazione (ultimi 30 giorni)
Mostra commenti meno recenti
xander fong
il 15 Lug 2015
Risposto: Geoff Hayes
il 15 Lug 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."
0 Commenti
Risposta accettata
Geoff Hayes
il 15 Lug 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 Commenti
Più risposte (0)
Vedere anche
Categorie
Scopri di più su Data Import from MATLAB in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!