How would automatically import excelfiles into MATLAB?
3 views (last 30 days)
Show older comments
JIN-HWA JEONG
on 3 May 2016
Commented: Image Analyst
on 3 May 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 Comments
Accepted Answer
Image Analyst
on 3 May 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 Comments
Image Analyst
on 3 May 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
More Answers (0)
See Also
Categories
Find more on Environment and Settings 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!