İmporting values form excel to matlab and use them in array

Question

fatih acar 2013-9-26

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/88296-importing-values-form-excel-to-matlab-and-use-them-in-array

编辑： Yatin 2013-10-16

hi,

I have excel documents which contain time-velocity values in two coloumns so i used xlsread command to import values to matlab for calculating distance but i have a problem

time = xlsread(filename,1,'coloumn1'); velocity = xlsread(filename,1,'coloumn2');

the problem is how can i use this values in a loop form beginnig to end.(I want to use for loop and how can i put this values in array one by one)

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

dpb 2013-9-26

在 MATLAB Online 中打开

doc for

has a couple of examples...

But, in general the idea in Matlab is to not use for...end loops unless mandatory; that "throws away" the power of vectorization that is the raison d'etre for Matlab to begin with.

What are you trying to accomplish--perhaps there's a better way (then again, sometimes a loop is the right answer, too).

请先登录，再进行评论。

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

Answer 1

Yatin 2013-10-16

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/88296-importing-values-form-excel-to-matlab-and-use-them-in-array#answer_99891

编辑：Yatin 2013-10-16

Hi,

By using the "xlsread" function you can directly get all the data from the excel sheet into a matrix. You can then directly obtain the individual columns of the matrix. For e.g: The first columns of the matrix (say M) will be M(:,1). You can then get the total number of elements in a column by using the " numel " function and then can iterate from 1 to the number of elements in the vector in a for loop. Hope this helps.