xlsread with file names in arrays

Question

Saeid 2017-3-15

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/329994-xlsread-with-file-names-in-arrays

回答： Guillaume 2017-3-15

I have 3 excel files with following names

'Input1.xls' 
'Input2.xls' 
'Input3.xls'

Is there a way to define an array such as:

InputFiles={'Input1.xls' 'Input2.xls' 'Input3.xls'}

so that I can write a loop where each file name is called based on its index:

for i=13
    datax=xlswrite(InputFiles(i))
end

I try this exactly as i just wrote but for some reason Matlab doesn't accept it.

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Guillaume 2017-3-15

在 MATLAB Online 中打开

It would help if you typed your example correctly,

I assume

for i = 13

is meant to be

for i = 1:3

and

data=xlswrite(...

is meant to be

data=xlsread(...

In what way matlab does not accept your code?

请先登录，再进行评论。

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

Answer 1

Guillaume 2017-3-15

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/329994-xlsread-with-file-names-in-arrays#answer_258833

在 MATLAB Online 中打开

Other than the many typos and the wrong brackets used to index the cell array, the main issue I can see with your code is that you constantly overwrite the same output, so at the end of the loop, you're only left with the content of the last file. This would fix this:

InputFiles = {'Input1.xls', 'Input2.xls', 'Input3.xls'};
Data = cell(size(InputFiles));   %preallocate output cell array for efficiency
for i = 1 : numel(InputFiles)    %don't hardcode the end of the loop when you can just ask matlab for the value
   Data{i} = xlsread(InputFiles{i});  %use {} to access the content of a cell
end