How would automatically import excelfiles into MATLAB?
3 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
JIN-HWA JEONG
le 3 Mai 2016
Commenté : Image Analyst
le 3 Mai 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 commentaires
Réponse acceptée
Image Analyst
le 3 Mai 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 commentaires
Image Analyst
le 3 Mai 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
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Environment and Settings dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!