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

2 次查看(过去 30 天)
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 个评论
dpb
dpb 2013-9-26
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).

请先登录,再进行评论。

回答(1 个)

Yatin
Yatin 2013-10-16
编辑: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.

类别

Help CenterFile Exchange 中查找有关 Logical 的更多信息

Community Treasure Hunt

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

Start Hunting!

Translated by