How would automatically import excelfiles into MATLAB?

1 次查看（过去 30 天）
JIN-HWA JEONG
JIN-HWA JEONG 2016-5-3
评论： Image Analyst 2016-5-3
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?

请先登录，再回答此问题。

采纳的回答

Image Analyst
Image Analyst 2016-5-3
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(.......
Please read the FAQ: http://matlab.wikia.com/wiki/FAQ#What_is_a_cell_array.3F
  3 个评论
显示 1更早的评论
Image Analyst
Image Analyst 2016-5-3
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

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by