How would automatically import excelfiles into MATLAB?
3 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
JIN-HWA JEONG
el 3 de Mayo de 2016
Comentada: Image Analyst
el 3 de Mayo de 2016
Hi, guys. I want to automatically import excelfiles into MATLAB. I use this code.
--------------------------------------------
source_dir = 'C:/Users/Cju/Documents/MATLAB/a' ;
source_files = dir(fullfile(source_dir, '*.xlsx'));
for i = 1:length(source_files) ;
data(i) = xlsread(fullfile(source_dir, source_files(i).name));
end
--------------------------------------------
But just import final file. What is wrong?
0 comentarios
Respuesta aceptada
Image Analyst
el 3 de Mayo de 2016
Chances are that won't work unless your workbooks have only a single scalar value in them. You would need data to be a cell array
data{i} = xlsread(.......
3 comentarios
Image Analyst
el 3 de Mayo de 2016
Just put this in the loop after you read in data{i}:
for k = 1 : length(data{i})
theMean(i, k) = mean(data{i});
end
Más respuestas (0)
Ver también
Categorías
Más información sobre Environment and Settings 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!