xlsread and its output argument in a for loop

Question

Hsinho Huang 2017-1-8

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/319473-xlsread-and-its-output-argument-in-a-for-loop

编辑： Stephen23 2017-1-8

I am wondering how to code a for loop to have the respective outputs from reading the 3 Excel files.

 [num1,txt1,raw1] = xlsread('D:\exp\data1.xlsx','sheet1','A5:F50');
 [num2,txt2,raw2] = xlsread('D:\exp\data2.xlsx','sheet2','A5:F50');
 [num3,txt3,raw3] = xlsread('D:\exp\data3.xlsx','sheet3','A5:F50');

I tried the following code but had an error 'Error: An array for multiple LHS assignment cannot contain M_STRING.'

 for i=1:3
 ['num',num2str(i)','txt',num2str(i)','raw',num2str(i)'] = xlsread('D:\exp\data',num2str(i),'.xlsx','sheet',num2str(i)','A5:F50');
 end

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Stephen23 2017-1-8

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/319473-xlsread-and-its-output-argument-in-a-for-loop#answer_249753

编辑：Stephen23 2017-1-8

在 MATLAB Online 中打开

Don't do this. Read this to know why:

https://www.mathworks.com/matlabcentral/answers/304528-tutorial-why-variables-should-not-be-named-dynamically-eval

You should simply import the data into cell arrays and use indexing. This will be much faster and more robust:

N = 3;
Cnum = cell(1,N);
Ctxt = cell(1,N);
Craw = cell(1,N);
for k = 1:N
    str = ['D:\exp\data',num2str(k),'.xlsx'];
    [Cnum{k},Ctxt{k},Craw{k}] = xlsread(str,'sheet',num2str(k)','A5:F50');
end