Determining the second last row
6 views (last 30 days)
Show older comments
Hi there,
How would you code the number of rows minus one? Below I use size() to find the number of rows, but I want to set nrows to the number or rows minus 1.
Many thanks
sch_cycle=xlsread('C:\Autonomie practice\cycle.xls','Input_data');
nrows = size(sch_cycle,1);
0 Comments
Accepted Answer
Jonathan Sullivan
on 16 Mar 2012
sch_cycle=xlsread('C:\Autonomie practice\cycle.xls','Input_data');
nrows = size(sch_cycle,1)-1;
0 Comments
More Answers (1)
Dr. Seis
on 16 Mar 2012
If you mean you want to set "sch_cycle" to have nrows - 1, then no need to actually determine "nrows" beforehand (just use "end"):
sch_cycle = sch_cycle(1:end-1,:);
You can setup an "if" statement in order to make sure "nrows" is greater than 1.
3 Comments
Dr. Seis
on 16 Mar 2012
Looks like "end" will still work there, too:
sch_cycle(1:max(1,end-1),:); % For all rows except last row
sch_cycle(max(1,end-1),:); % For just second to last row
See Also
Categories
Find more on Creating and Concatenating Matrices 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!