Read data using xlsread and store in a variable

Hi I have an Excel file with 1000 rows and i want to pick 30 random rows from it, i used xlsread command to read the excel data in for loop, i want to save all the rows read from the file but the issue i am facing is that when i save in a MAT file (using save command) i just only the last row that overwrites all other rows. please answer quickly,i am very thankful

Answer 1

[XueJing Yu]

Maybe you can read all data and then select rows using function "resample".

data = xlsread(yourFileNameHere);

nTotalRows = 30;

nSelection = 10;

selectedRowIndex = datasample(1:1:nTotalRows,nSelection,'Replace',false);

dataSelection = data(selectedRowIndex,:);