reading values

7 次查看（过去 30 天）
kash
kash 2012-1-25
I have some data ,i tried using xlsread ,but final column is not dsiplaying
A=
12 36 45 858 8 1 >50
10 2 1 21 20 0 <=50
like these i have 30000 rows and 6 columns,now i want to read all the column and store the last column in separate variable,please help

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

回答（2 个）

Image Analyst
Image Analyst 2012-1-25
How about this:
separateVariable = array2D(:,end);
  4 个评论
显示 2更早的评论
kash
kash 2012-1-25
column1 colmun2 column3 column4 column 5 column6 column7
10 2 1 21 20 0 <50
these i have stored as dataset.xls
now i want to read all datas and display
next i want last column to be stored in separate variabe ,
then in that last column i want to count how values are there
which is >50,<=50
Image Analyst
Image Analyst 2012-1-25
Do what I said then. The to get the sum of the number of elements where the value <= 50:
summedUp = sum(lastColumn<=50);

请先登录，再进行评论。

Walter Roberson
Walter Roberson 2012-1-25
How did you do the xlsread() ? That final column is going to be discarded (or 0 or NaN) in the (default) numeric output, available only in the second (text) output or third (raw) output.

类别

在 Help Center 和 File Exchange 中查找有关 Low-Level File I/O 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by