清空筛选条件
清空筛选条件

importing data from excel, finding the last row and inserting value in a matrix

3 次查看（过去 30 天）
John
John 2011-12-19
Hi,
I'm importing data into Matlab from excel via the following command:
cycle=xlsread('E:\dc.xlsx','Sheet1')
I do not know the number of the last row of data.
But I need to create a 2D matrix 'grade' with zero-zero on the first row and the number of the last row of data in the excel sheet and 0 on the second row.
For example if the last row of data was on the 10th row then 'grade' would be:
grade = [0 0;10 0];
How would I do this if I do not know the number of the last row of data in advance?
May thanks

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

采纳的回答

Matt Tearle
Matt Tearle 2011-12-19
If you're already reading in the data, why not just query its size?
nrows = size(cycle,1);
grade = [0,0;nrows,0];

更多回答（1 个）

Patrick Saegesser
Patrick Saegesser 2011-12-19
did you try
size(cycle,1)
size along dimension 1 (rows) will give you the length of your dataset, and assuming you don't have any NaN in your set, it is the number of the last row.
you can then assign any variable, e.g.
Last = size(cycle,1)
Grade = [0,0;Last,0]
and get your output.

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by