Read data using xlsread and store in a variable

2015 3 20
1 个回答
回答已采纳
更新时间：2015 3 20
2 次查看（30 天）

0 个投票

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

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

 采纳的回答

XueJing Yu
XueJing Yu 2015-3-20

0 个投票

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,:);

更多回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by