Basic Excel Import Error
1 visualización (últimos 30 días)
Mostrar comentarios más antiguos
xander fong
el 15 de Jul. de 2015
Respondida: Geoff Hayes
el 15 de Jul. de 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 comentarios
Respuesta aceptada
Geoff Hayes
el 15 de Jul. de 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 comentarios
Más respuestas (0)
Ver también
Categorías
Más información sobre Data Import from MATLAB en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!