How would automatically import excelfiles into MATLAB?

3 次查看（过去 30 天）

显示更早的评论

JIN-HWA JEONG 2016-5-3

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/282255-how-would-automatically-import-excelfiles-into-matlab

评论： Image Analyst 2016-5-3

采纳的回答： Image Analyst

在 MATLAB Online 中打开

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 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

采纳的回答

Image Analyst 2016-5-3

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/282255-how-would-automatically-import-excelfiles-into-matlab#answer_220511

在 MATLAB Online 中打开

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更早的评论隐藏 1更早的评论

JIN-HWA JEONG 2016-5-3

Where I put the fuction related average ?

Image Analyst 2016-5-3

在 MATLAB Online 中打开

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

请先登录，再进行评论。

类别

MATLAB Environment and Settings

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

Community Treasure Hunt

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

Start Hunting!

Translated by