reading values
3 views (last 30 days)
Show older comments
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
Answers (2)
Image Analyst
on 25 Jan 2012
How about this:
separateVariable = array2D(:,end);
4 Comments
Image Analyst
on 25 Jan 2012
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
on 25 Jan 2012
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.
0 Comments
See Also
Categories
Find more on Data Type Conversion in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!